I am having a brain fart! I want the cell in D to total of all of B:B where what is in A:A is in C. Something like =SUMIF(A2:A19,C2,B2:B19)
Untitled.png
I am having a brain fart! I want the cell in D to total of all of B:B where what is in A:A is in C. Something like =SUMIF(A2:A19,C2,B2:B19)
Untitled.png
Last edited by builderific; 10-01-2013 at 03:17 PM.
please post a workbook instead of a picture, so folks can work out a formula for you
When I say semicolon, u say comma!
Hi and welcome to the forum :0
the sumif() syntax is...
=SUMIF(criteria-range, criteria,sum-range)
so maybe....
=sumif(A:A,C1,B:B)
also, please dont upload pics, rather send us a sample workbook
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Sorry new to this forum so I have not figured out how to upload a workbook.
That is what I was afraid of. Sumif is not really what I need I think... Sumif says that the value in A:A would be the same as the value in C1.
I need the cell at say D3 to total up all of the values in B:B where the text in A:A exists in C3.
Hi builder
This seems to do what you're asking for I think
Please Login or Register to view this content.
It dawned on me that Excel 2003 might not have the Iferror function. Dunno as I've never used it.
Here's another alternative
Please Login or Register to view this content.
builder, your profile says 2003, but your upload indicates 2007 or later, please update your profile as needed. Members often tailor a suggestion based on the version you say you have (see above lol)
Also, I would suggest you include a few sample answers and show how you arrived at them please
Phil, the file is 2007 or later so IFERROR() should work, and no, 2003 does not support that function.
welcome to the forum, builderific. try this in D2:
=SUMPRODUCT(ISNUMBER(SEARCH(" "&$A$2:$A$93&","," "&C2&","))*$B$2:$B$93)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thank you all!
Last edited by builderific; 10-02-2013 at 10:03 AM.
Thank you benishiryo! That was the ticket! You guys rock!
Profile Updated! Thanks again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks