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