Hi,

I am trying to use the SUMIFS function to evaluate a sum based on two criteria. The formula I am using is:

=SUMIFS(Teaching!$V$6:$V$218,Teaching!$C$6:$C$218,C5-2500,Teaching!$D6:$D218,0)

which, as far as I can tell, is of the correct form. Column C contains numbers identifying a category, and column D is mostly blank except for a few rows which contain a short string. I want to sum all those figures in column V which belong to a certain category (calculated by C5-2500) but excluding those which have a string in column D - i.e. only those where the cell in column D is blank.

When I enter the formula with only the first criterion it evaluates correctly, but on adding the second it always evaluates to zero.

Can anyone spot what is going wrong with this?

Thanks!