sumif

sumif

Didn't find your answer?

Hi

Can you use multiple subif?

sumif(X,XY,XY)+sumif(X,XY,XY)+sumif(X,XY,XY)

thanks

Replies (7)

Please login or register to join the discussion.

avatar
By paulwakefield1
25th Feb 2015 18:48

Simple answer is Yes

There may be other ways of achieving what you want

Thanks (0)
avatar
By Norfolkfella
26th Feb 2015 07:41

Sumifs is what you need.
=SUMIFS(Range,Criteria1,Criteria2,Criteria3.....)

Thanks (0)
avatar
By paulwakefield1
26th Feb 2015 08:49

If I have understood

the OP correctly, I think SUMIFS will be difficult (not necessarily impossible) because it applies multiple criteria to a range or ranges rather than adding items from the range meeting different criteria. i.e. the criteria are "AND" rather than "OR" and it restricts rather than expands selection.

Thanks (0)
avatar
By Norfolkfella
26th Feb 2015 09:20

May be right....
We need OP to specify what he is trying to achieve I guess

Thanks (0)
avatar
By qwertyqwerty05
26th Feb 2015 09:42

Thanks for your input.

Yes I meant sum X + sum X

Thanks all

Thanks (0)
avatar
By qwertyqwerty05
26th Feb 2015 09:43

To clarify AND, not OR

Thanks (0)
pic
By jndavs
26th Feb 2015 13:46

sumif()
Used normally, the result of a sumif is just a number, so of course you can add them together.

Thanks (0)