SUMIFS when no values to sum

Hi,

I am using the SUMIFS function to sum data.

In my data some of the criteria are only associated with "n/a" in the sum_range for the period, rather than actual numerical values. However, SUMIFS evaluates this as zero, which is not what I want. Instead I'd rather "n/a" was returned if there are no values to add.

Can someone please suggest how I do this.

Thanks!

Try

=IF(SUMIFS(.......),SUMIFS(.....),"N/A")

e.g

=IF(SUMIFS(B2:B400,A2:A400,1),SUMIFS(B2:B400,A2:A400,1),"n/a")

Works a treat, thanks!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.