Can you sum multiple columns based on two conditions?
I have a selection of data that ranges from column D:DE
In column B is condition 1 in Column C is condition 2
I have tried
Formula:
Please Login or Register to view this content.
and
Formula:Please Login or Register to view this content.
But i am getting either £0.00 or #Value or #N/A
Whats wrong here?
Dan
Do you mean?
=Sumproduct(('Data'!$B:$B=B10)*('Data'!$C:$C=C9)*('Data'!$D:$DE))
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.
Try
=SUMPRODUCT((Data!$B:$B=B10)*(Data!$C:$C=C9),Data!$D:$DE)
however restrict ranges to only those that contain data and not full column refernces.
Life's a spreadsheet, Excel!
Say thanks, Click *
Try this.
with Ctrl + Shift + Enter
Formula:Please Login or Register to view this content.
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Hi
I have tried all of your suggestions and still get £0.00, or #Value, i have decided i am going to build a column to sum the cells i need to then just use a sumifs function to look at that column based on the two conditions
Thank you for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks