Hi,
I am trying to use SUMIF to sum a range based on three conditions.
I am trying to use formula to match the month, a total line and then a user dependent drop down list.
I only get an error but I dont know why this would be, any ideas why?
The formulas should be in the yellow highlighted cells C52:N53
Paul
Could a helper column work for you (that is how i'd do it)?
add a column that concatinates columns A and B into col C then use
=SUMIF($C$2:C$49,D$51&$B53,$D$2:$AU$49)
this one was in cell D53.
Last edited by Sam Capricci; 07-25-2013 at 10:48 AM.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
@ pauldaddyadams
As i see you online, can you tell us what did you do in this your own thread?
http://www.excelforum.com/excel-form...t-formula.html
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,
Unfortunately if I do that it omits the 3rd lookup - this is in B51 which matches row 1.
Paul, i think that for 1 more time you need SUMPRODUCT.
=SUMPRODUCT(($B$2:$B$49=$B52)*($A$2:$A$49=C$51)*($C$1:$AT$1=$B$51)*($C$2:$AT$49))
Unfortunately I'm really not following what you are looking for then.
What would be the value that should appear in (your original) cell C52?
Fotis you have done it again! Needless to say it works perfectly!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks