SUMIF and multiple ranges

  • Thread starter Thread starter Brian
  • Start date Start date
B

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?
 
Hi
is there a logic behind your used ranges. e.g. every 10th row is not
included, etc.
 
You could add individual SUMIF formulas, e.g.:

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

Debra Dalgleish said:
You could add individual SUMIF formulas, e.g.:

=SUMIF('Co loan accounts'!M12:M22,"<0") +
SUMIF('Co loan accounts'!M25:M32,"<0")
Click to expand...
 
Back
Top