LinkBack URL
About LinkBacks
I am trying to do a sumifs with two criteria but I want the criteria to lookup the text in a cell. I have tried several different things but I cant seem to get the formula to give me anything but 0 unless i type the text in
I am trying to do a sumifs with two criteria but I want the criteria to lookup the text in a cell. I have tried several different things but I cant seem to get the formula to give me anything but 0 unless i type the text in
Last edited by bbeards2; 11-06-2015 at 04:09 PM. Reason: Solved
Please post a file explaining what you need.
Here is an example of the issue I am having. Would it make a difference if the the criteria and range were numbers?
Simple error: "bad" in G1 was "bad " - extra blank!
I want the formula in E2 to work.
Last edited by bbeards2; 11-06-2015 at 03:48 PM.
It does work if you change "bad " in G1 to "bad" - remove the blank at the end of "bad" !!! (as per my previous post).
I have tried removing the space but it is still showing zero. I tried applying the trim formula and still nothing.
Formula is ..
=SUMIFS($A$2:$A$8,$B$2:$B$8,G1,$C$2:$C$8,H1)
Sorry ... I should have posted this earlier.
You have your cell references inside quotes therefore excel sees them as text and not as cell references (i.e. it would count how many times H1 appears in B1:B12)
=SUMIFS($A$2:$A$8,$B$2:$B$8,G1,$C$2:$C$8,H1)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks