SUMIF and multiple ranges

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?
 
F

Frank Kabel

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

Debra Dalgleish

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

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

Brian

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Columns in Sum Range using SUMIFS 1
Use TODAY() function as the criteria in a SUMIF formula 1
Multiple Email Accounts and Calendars 0
SUMIFS, one criteria range, multiple criteria 2
First row where a cell is zero 2
SumIf equation question 6
Lookup within a range 3
When amortising a loan based using an IRR rate, the total interestpaid fall short. 0

Top