Hi,
I am running excel 2003 and wants to add a function that shall sum the values of the cells in Column A1:A100 in case the values in corresponding cells in Column B1:B100 equals "Y" and corresponding cell values in Column C1:C100 equals "N".
I appreciate any help.
Marcus
Try
=SUMPRODUCT((B1:B100="Y")*(C1:C100="N")*(A1:A100))
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 - You can use Sumproduct to achieve this. Try:
Formula:
Please Login or Register to view this content.
If solved kindly remember to mark Thread as solved.
Click the small star icon at the bottom left of my post if this was useful.
Thx,
but I do not think excel 2003 allow this formula to use differeent data types. The values in A1:A100 are numbers and B and C is plain text. Will this still work? I get error in my excel.
Should work in 2003. Can you upload workbook please
Why do you say this?
Sorry,
I made wrong column referenc e in my sheet. That's why I got problems with data. It works no.
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