Please see the attached workbook.
Column I, daily cost is using the SUMIF function.
Basically, if he attended daycare that day, it needs to add the daily cost (D), the cost for activity 1, (F) and the cost for activity 2 (H).
The result is only giving me the daily cost.
Please help!
SOLVED: =IF(C4="Y",SUM(D4:H4),0) worked!
Bookmarks