Working like a charm. Question now on what happens if you add rows in the
table, will the formula automaically pick up the cell range change or would a
person have to make that correction

"Techno Grandma" wrote:

Thanks Max I will give it a try

"Max" wrote:

Typo in range, it should be:
In F50: =SUMIF(F4:F7,"day",E4:E7)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---