SUMIF Non-Continuous Range

K

Kirk P.

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,BD38),"<>0")
 
D

Domenic

Wouldn't the following suffice?

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

Hope this helps!
 
K

Kirk P.

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