SUMIF and multiple ranges

[Brian]

I want to use SUMIF with multiple ranges.

The following formula works OK:

=SUM('Co loan accounts'!M12:M22,'Co loan accounts'!M25:M32)

However, the following does not:

=SUMIF('Co loan accounts'!M12:M22,'Co loan accounts'!M25:M32,"<"&0)

Is there a way of doing this, or do I have to use some kind of workaround?

 

[Frank Kabel]

Hi
is there a logic behind your used ranges. e.g. every 10th row is not
included, etc.

 

[Brian]

No, there is no regular system.

Hi
is there a logic behind your used ranges. e.g. every 10th row is not
included, etc.

 

[Debra Dalgleish]

You could add individual SUMIF formulas, e.g.:

=SUMIF('Co loan accounts'!M12:M22,"<0") +
SUMIF('Co loan accounts'!M25:M32,"<0")

 

[Brian]

Many thanks.

You could add individual SUMIF formulas, e.g.:

=SUMIF('Co loan accounts'!M12:M22,"<0") +
SUMIF('Co loan accounts'!M25:M32,"<0")