I want to add numbers in column B if Bob is found in column A. I'm using =SUMPRODUCT(--(A1:A100="Bob"),B1:B100), but I keep getting a result of 0. What the heck am I doing wrong?
I want to add numbers in column B if Bob is found in column A. I'm using =SUMPRODUCT(--(A1:A100="Bob"),B1:B100), but I keep getting a result of 0. What the heck am I doing wrong?
Last edited by AnnaV; 05-10-2011 at 11:00 AM.
Nevermind. I changed "AB" to a cell reference and it worked.
Do the Bob's in column A contain extra spaces before or after?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Since it is one condition you are checking, you can use SUMIF which is more efficient:
=SUMIF(A1:A100,"Bob",B1:B100)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks