Hi ,
I get excel sheet like this with 6000 rows and so.
I first sort the data to get all teh relevant groups together
but the in row732 ,379,34,3 i manually go and do total and do sum.
Can you please help me find a better way to do this
Thanks
mp
Hi ,
I get excel sheet like this with 6000 rows and so.
I first sort the data to get all teh relevant groups together
but the in row732 ,379,34,3 i manually go and do total and do sum.
Can you please help me find a better way to do this
Thanks
mp
Do Data>Subtotal.
Hi mp and welcome to the forum
If i get your point then try with SUMIF.
For example, yo find the total amount of dbsb,use this formula. Same for the others.
=SUMIF(C:C;"dbsb";E:E)
Hope to helps you.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hi I am not getting answers as expected when i use the subtotal.. i wan the total to be calculated based on country, account and product
it ahs to subtotal based on these criteria
there could be same products under same account and country.
Hwo would i achive that plesae
mp
Try using a Pivot Table
Can you please help me do that please
i am new to pivot and all
thanks
mp
This page will get you started
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks