LinkBack URL
About LinkBacks
For some reason this isn't working. I want it to sum Column F if Column A has a certain value and if Column B contains one of three possibilities. This function will not work however! I'm getting a sum of 0.
SUMIFS(F1:F1,A1:A1,8,B1:B1,OR(4,7,9))
For some reason this isn't working. I want it to sum Column F if Column A has a certain value and if Column B contains one of three possibilities. This function will not work however! I'm getting a sum of 0.
SUMIFS(F1:F1,A1:A1,8,B1:B1,OR(4,7,9))
try
SUMIFS(F1:F1,A1:A1,8,B1:B1,4)+SUMIFS(F1:F1,A1:A1,8,B1:B1,7)+SUMIFS(F1:F1,A1:A1,8,B1:B1,9)
although your range is only row 1
is that what you wanted ?
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi,
You've only specified ranges containing a single row. But in any case you are effectively trying to perform an AND.
Try instead
Formula:
=SUMIFS(F:F,A:A,8,B:B,4)+SUMIFS(F:F,A:A,8,B:B,7)+SUMIFS(F:F,A:A,8,B:B,4)+SUMIFS(F:F,A:A,8,B:B,9)
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
I know, I'm just trying to keep it simple for the sake of the thread. I know I could add multiple SUMIFS together, but I actually have more than one column where there is more than one possibility, and this would quickly get unwieldy.
Well the syntax you show isn't recognised so you can't do it that way. One way or another you are going to have to use multiple functions.
Perhaps an easier option would be to use a helper columns which uses an
Formula:=IF(OR(B1=4,B1=7,B1=9...etc),"Yes","No")
formula and then use the helper column in the SUMIFS() formula.
I don't understand why "SUMIF/SUMIFS" won't sum a function if the criteria OR(blablabla) is true. It seems so simple. Does A1 = 3 or 4? Yes, great, sum it!
Try it like this...
Data Range
This formula entered in D2:
=SUM(SUMIFS(F1:F10,A1:A10,8,B1:B10,{4,7,9}))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks