Large Function returns zero

[GStorm]

This is the formula in G15. =SUMIF(G4:G13,">=LARGE(G4:G13,7)",E4:E13)
If I replace the criteria with =SUMIF(G4:G13,">=2.96",E4:E13) everything works.
If I put =LARGE(G4:G13,7) in a separate cell I get back 2.96

I do not know why the sumif cannot evaluate the correct LARGE function.

 

[Cubist]

Try putting it outside the string.

=SUMIF(G4:G13,">=" & LARGE(G4:G13,7),E4:E13)

 

[GStorm]

That did it!, thank you for such a quick reply.

 

[Cubist]

No problem.