Hai frnds..
I want to need help
In the attached sheet, i want the total weight of particular party, both meals and oil.
Hai frnds..
I want to need help
In the attached sheet, i want the total weight of particular party, both meals and oil.
Last edited by Shilpa kanchan; 07-30-2012 at 04:41 AM.
Hi You can use pivot table for this
p.s. change the title of Your post
Last edited by tom1977; 07-30-2012 at 03:25 AM.
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
no i dnt use pivot table.. can't i use any formula
Hi
Something like this in B2?
=SUMIFS(Data!$C$2:$C$12,Data!$A$2:$A$12,A2,Data!$B$2:$B$12,"Oil")
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.
extract unique names then use sumifs...
sumifsdummy.xlsx
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks