=sumifs(a2:a5, b2:b5, "=3.25", c2:c5, "=360")
=sumifs(a2:a5, b2:b5, "=3.25", c2:c5, "=360")
I got the formula to work, but now I am needing to add another condition and it is not working. Can you tell me what is wrong with this formula?
=SUMIFS($A$2:$A$47,$B$2:$B$47,4%,$C$2:$C$47,120,$C$2:$C$47,180)
Thanks for your help!
You're testing the range C2:C47 for 2 different conditions at the same time.
C2:C47 = 120
C2:C47 = 180
The cells can not = 120 and 180 at the same time so the result will always be 0.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Ok, I understand that. So what do you do if you want to sum up numbers from column A that have a specific rate in column B and EITHER a 120 OR 180 in column C?![]()
Like this...
=SUM(SUMIFS($A$2:$A$47,$B$2:$B$47,4%,$C$2:$C$47,{120,180}))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks