Right now I have this
=IF((B9=yes),SUM(C9))
101 yes 50.22
101 no 60.13
501 yes 75.5
I'd like it to only sum if "A" is 101, I'm sure this is simple and i'm just having a duh moment.
Right now I have this
=IF((B9=yes),SUM(C9))
101 yes 50.22
101 no 60.13
501 yes 75.5
I'd like it to only sum if "A" is 101, I'm sure this is simple and i'm just having a duh moment.
May be this...
Formula:Please Login or Register to view this content.
Or
Formula:Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Perfect! This is the one I used =IF(AND(A9=101,B9="yes"),C9,"")
Thank you!!
Try this
and it should work, you can replace the "yes and the '101" with a cell reference to allow for different criteria if needed. Good luck!Please Login or Register to view this content.
Sorry I typed that completely wrong
Last edited by Tank997; 03-20-2013 at 03:05 AM.
Tom S.↙ If you find my reply helpful click on the * down there on the left. Yeah that's it, right there, down on the leftIf your question is resolved, mark it SOLVED using the thread tools.
Glad it helps you and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks