sumif problem

[i0mega]

Hello

Im not if Im using the correct formula for what i want, but I cant work it out

Im using this =SUMIF(E5:G5,">24",1)

What Im asking is: IF the sum of E5:G5 equals more than 24, then display a 1.

Can some one help tell me where Im going wrong. Thank you

 

[Jonmo1]

Try

=IF(SUM(E5:G5)>24,1,"")

 

[JazzSP8]

Hi

Try;

=IF(SUM(E5:G5)>24,1,"")

 

[Trevor G]

Hello

Im not if Im using the correct formula for what i want, but I cant work it out

Im using this =SUMIF(E5:G5,">24",1)

What Im asking is: IF the sum of E5:G5 equals more than 24, then display a 1.

Can some one help tell me where Im going wrong. Thank you

Try this

Excel Workbook
	E	F	G	H
5	2	56	12	1
Sheet1

 

[i0mega]

Brilliant thank you