Calculate Total Sales for Rajasthan in Excel (Full Transcript)

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