Calculate Total Sales for Rajasthan in Excel
Learn how to use a formula to sum values for Rajasthan in Excel columns C and D.
File
Time Saving Chat Gpt Tips in Excel excel shorts chatgpt
Added on 01/29/2025
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
Summary

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

Generate
Title

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

Generate
Keywords

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

Generate
Enter your query
Sentiments

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

Generate
Quizzes

Create interactive quizzes based on the content of the transcript to test comprehension or engage users.

Generate
{{ 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