ExcelBanter - SUMIF and range

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SUMIF and range (https://www.excelbanter.com/excel-worksheet-functions/208312-sumif-range.html)

Compass Rose

SUMIF and range

Is it possible to have non-contiguous (I think that's the right word) ranges
in a SUMIF statement? If so, is this the correct syntax to define the range?
For example:

=SUMIF(A2:A14,A17:A25,"0",R2:R14,R17:R25)

TIA

David

Peo Sjoblom[_2_]

SUMIF and range

Try

=SUM(SUMIF(INDIRECT({"A2:A14","A17:A25"}),"0",IND IRECT({"R2:R14","R17:R25"})))

--

Regards,

Peo Sjoblom

"Compass Rose" wrote in message
...
Is it possible to have non-contiguous (I think that's the right word)
ranges
in a SUMIF statement? If so, is this the correct syntax to define the
range?
For example:

=SUMIF(A2:A14,A17:A25,"0",R2:R14,R17:R25)

TIA

David

Ashish Mathur[_2_]

SUMIF and range

Hi,

Use 2 SUMIF() functions instead.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Compass Rose" wrote in message
...
Is it possible to have non-contiguous (I think that's the right word)
ranges
in a SUMIF statement? If so, is this the correct syntax to define the
range?
For example:

=SUMIF(A2:A14,A17:A25,"0",R2:R14,R17:R25)

TIA

David

All times are GMT +1. The time now is 09:27 AM.