Calculating numbers only with Sumifs

[Helix242]

Hi all,

I hope you can help. I am using a SUMIFS formula to count totals in column D - however the will be times when a letter will be listed instead of a number, which obviously causes the formula to fail. I have used connotations of ISNUMBER within the formula, but none of these work.

Any assistance or guidance would be much appreciated.

Many thanks in advance

Mark

=SUMIFS(ENTRIES!D5:D9998,ENTRIES!$C$5:$C$9998,">="&$C$3,ENTRIES!$C$5:$C$9998,"<="&$C$4)

 

[Joe4]

Which column has the letters?
If it is column D, it will just ignore those values (no errors), so it should work properly.

Are the letters in your criteria column, column C?

It might be helpful to post a small sample of your data so we can see exactly what you are working with.

 

[Helix242]

Which column has the letters?
If it is column D, it will just ignore those values (no errors), so it should work properly.

Are the letters in your criteria column, column C?

It might be helpful to post a small sample of your data so we can see exactly what you are working with.

Please accept my apologies. There was a hidden sheet which I had forgotten about (I know I'm an idiot!) which was feeding into the formula, and the error was in that sheet. All sorted now! Oops! lol