ExcelBanter - SUMIF Non-Continuous Range

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

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

- - SUMIF Non-Continuous Range (https://www.excelbanter.com/excel-worksheet-functions/114323-sumif-non-continuous-range.html)

Kirk P.

SUMIF Non-Continuous Range

This SUMIF function isn't working. Is it the non-continuous range it doesn't
like?

=SUMIF(R38,S38:T38,V38:Y38,AA38:AC38,AQ38,AZ38,BD3 8),"<0")

Domenic

SUMIF Non-Continuous Range

Wouldn't the following suffice?

=SUM(R38,S38:T38,V38:Y38,AA38:AC38,AQ38,AZ38,BD38)

Hope this helps!

In article ,
Kirk P. wrote:

This SUMIF function isn't working. Is it the non-continuous range it doesn't
like?

=SUMIF(R38,S38:T38,V38:Y38,AA38:AC38,AQ38,AZ38,BD3 8),"<0")

Kirk P.

SUMIF Non-Continuous Range

Yes it does suffice, I realized almost immediately after posting the question
it was a dumb question!

"Domenic" wrote:

Wouldn't the following suffice?

=SUM(R38,S38:T38,V38:Y38,AA38:AC38,AQ38,AZ38,BD38)

Hope this helps!

In article ,
Kirk P. wrote:

This SUMIF function isn't working. Is it the non-continuous range it doesn't
like?

=SUMIF(R38,S38:T38,V38:Y38,AA38:AC38,AQ38,AZ38,BD3 8),"<0")

All times are GMT +1. The time now is 04:54 PM.