Sumifs not working

[TWTHOMAS]

Will sumifs work with a formula result?

I have a sheet this formula works perfectly on.

=SUMIFS(Schedule!C:H,Schedule!B:G,"Wildcats")

Columns c and h are both simply numbers.

However I have these two formulas in columns e and j ....

Column E
=IF(C3>H3,"3",IF(C3<H3,"0",IF(C3=H3,"1")))

Column J
=IF(H3>C3,"3",IF(H3<C3,"0",IF(H3=C3,"1")))

And this formula will only result in zero regardless of what I have tried.

=SUMIFS(Schedule!E:J,Schedule!B:G,"Wildcats")

If I input a number into either column and overwrite the formula, I get that sum. But although the formula results in a number, the sumifs will not work.

I've tried a simple =c2 in a new column and referenced that cell in the sumifs but still get zero as the result. I checked the format of the cells and they are definitely numbers. I've checked for invisible characters, and there appear to be none.

Help?

 

[Joe4]

Note that when writing formulas, if you want numeric results, you should NOT enclose the number to return in double-quotes.
Double-quotes are used to denote text entries, not numeric ones.

So try changing your formulas in column E and J to:

=IF(C3>H3,3,IF(C3<H3,0,IF(C3=H3,1)))

and

=IF(H3>C3,3,IF(H3<C3,0,IF(H3=C3,1)))

 

[Fluff]

You need to get rid of the quotes surrounding the numbers in the columns E & J, otherwise they are text

 

[TWTHOMAS]

Outstanding! You guys are so incredibly helpful.

 

[Joe4]

You are welcome.
Glad we were able to help!