[baldrod]

Can anyone help me figure this out? I am running out of time for a dead line and this is the last stumbling box I have.
I have 16 rows and at the end of each row is a total in the last row is the bottom of the column that totals the rows above it. If any of the 16 rows are <40 I want it to total them in the bottom row if they are >40 I dont want a total in the bottom row and I would like it to highlight the box if there is a sum in the bottom row and not highlight if it is empty.

I am using Office 2007

[User3]

I am using office 2003. I can get more help this site. the end of each row is a total in the last row is the bottom of the column that totals the rows above it. If any of the 16 rows are <40 I want it to total them in the bottom row if they are >40 I dont want a total in the bottom

[Aj_old]

If you wanna to sum all cells that have value grater than or equal to 40 then write this:

A17=SUMIF(A1:A16,">=40")

If you wanna to sum if in the columns is at least one value less than 40, then write this:

B17=IF(COUNTIF(B1:B16,"<40")>=1,SUM(B1:B16),"")

To highlight cells in row 17, that have sum in it, select the row 17, go to Format\Conditional formating, select "Cell Value is", "not equal to", and type "="""

[baldrod]

Thanks so much for the help I always know where to go when the going gets tough