Calculate Total Sales for Rajasthan in Excel (Full Transcript)

Learn how to use a formula to sum values for Rajasthan in Excel columns C and D.
Download Transcript (DOCX)
Speakers
add Add new speaker

Speaker 1: For example, I have type Product, Category, State, Amount I want to show that we have sold in Rajasthan many times So I want to show only Rajasthan, Rajasthan in total Right now, I am not able to remember any formula that which formula should be used here or which command should be used here to make it in total, only Rajasthan So I will ask this same question to same to same chat GPT So I have typed my question like this I have an Excel sheet In this, type State in Column C and type Amount in Column D which you can check here Type State in Column C and type Amount in Column D I have typed the same there In this, I have to type only Rajasthan in total What formula will be there? Now see here, it has started generating the answer See here, it has given a formula I will copy it from here After copying, I will go to my Excel and I will paste it in an empty cell See, it is showing The total Rajasthan cell is 84381

ai AI Insights
Arow Summary

Generate a brief summary highlighting the main points of the transcript.

Generate
Arow Title

Generate a concise and relevant title for the transcript based on the main themes and content discussed.

Generate
Arow Keywords

Identify and highlight the key words or phrases most relevant to the content of the transcript.

Generate
Arow Key Takeaways

Extract key takeaways from the content of the transcript.

Generate
Arow Sentiments

Analyze the emotional tone of the transcript to determine whether the sentiment is positive, negative, or neutral.

Generate
Arow Enter your query
{{ secondsToHumanTime(time) }}
Back
Forward
{{ Math.round(speed * 100) / 100 }}x
{{ secondsToHumanTime(duration) }}
close
New speaker
Add speaker
close
Edit speaker
Save changes
close
Share Transcript