Hello, I'm having some difficulty trying to use the SUM and ROUNDDOWN function. I have the following formula "=IF(ISTEXT(D3),IF(D3="Basic",SUM(L3:AP3)+COUNTIF(L3:AP3,"NA"),""),"")". This formula looks in column D to see the rate, then sums the entries in cells L:AP. In some cases I need to enter .5 in L:AP so I need to add the ROUNDDOWN function to be able to count full days. Thanks for the help.