hi,
i want to subtotal of my filtered data but with one criteria
column(c) = criteria data (criteria will match with this column )
column(d) = filtered data (filter will apply on this column )
column(e) = sum data ( the data of this column will sum )
for example
i filter my range ("c10:e500")
now i want to sum of column d with criteria "4 OL BC" , "5 OL J" , "6 OL JT"
In below sample if i filter "aam" then the sum will be "41"
Capture.JPG
thank you
Last edited by HaroonSid; 05-24-2017 at 08:35 AM.
Use Code-Tags for showing your code :
Please mark your question Solved if there has been offered a solution that works fine for you
If You like solutions provided by anyone, feel free to add reputation using STAR *
Do you mean?
Formula:
Please Login or Register to view this content.
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.
Thank you Fotis1991 for the reply
but i need like this one
Please Login or Register to view this content.
Sorry i miss-understoond your question!
i did plus three formulas of you, after did this i am getting what i want
any hope you do with one formula what i want
Try
=SUMPRODUCT((($C$11:$C$1000="4 OL BC")+($C$11:$C$1000="5 OL J")+($C$11:$C$1000="4 OL JT"))*(SUBTOTAL(109,OFFSET(E11,ROW($E$11:$E$1000)-MIN(ROW($E$11:$E$1000)),0))))
Thnk you JohnTopley and Fotis1991
@johnTopley its working perfectly
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks