SumIf Error

Afternoon,

I have written the formula below, to sum a range of data, if it corresponds to January.

=SUMIF($Q$17:$Q$65536,"January",$R$17:$R$65536)

However, at times there will be an error in the sum range (#N/A)

What I would like is a formula, based on the above, that will tell Excel to ignore any cell which has an error.

Alternatively - if this is not possible, if there is an error in the sum range, the total should = " ".

Regards

Howardjo

try using
=if(iserror(yourformula)," ",yourformula)

To treat errors in the sum range as zeroes try this array formula

=SUM(IF($Q$17:$Q$65536="January",IF(ISNUMBER( $R$17:$R$65536),$R$17:$R$65536)))

needs to be confirmed with CTRL+SHIFT+ENTER so that curly braces like { and } appear around the formula in the formula bar

Thanks for your time in looking at this,

I have this working now.

Regards

Howardjo