Display message in cell based on sum of cells on other worksheet

[Human_doing]

Hi all,

I am looking to put together a formula that sums cells B3:B6 on sheet 1 and then displays message 'compliant' if the sum result is above 30 and 'non-compliant' if below 30 in a cell on sheet 2, could anyone please help? I am using Excel 2003, formulae are not my strong suit.

Formula I have so far is:

=IF(Sheet1!B3:B6)>30,"Compliant","Non-compliant")

Many thanks for any help,

 

[VoG]

Try

=IF(SUM(Sheet1!B3:B6)>30,"Compliant","Non-compliant")

 

[doofusboy]

=IF(SUM(Sheet1!B3:B6)>30,"Compliant","Non-compliant")

 

[anglais428]

=IF(SUM(Sheet1!B3:B6)>30,"compliant","non-compliant")

 

[Human_doing]

Thanks so much everybody!