My IF Formula only works in certain cells in my grid

Jewelle W

I have a formula in my sheet that sums the hours by project, phase and category. Ie for a row with task 1 I get the sum of (1) total hours logged on timesheets, (2) Design Engineer Hours (2) Senior Design Engineer Hours, and (3) Principal Hours. The formulas are as follows:

1. Total Hours: =IF([Budget:]@row > 0, SUMIFS({TS WIP Incurred Hours}, {TS WIP Project Name}, [Project Name | Helper]1, {TS WIP Phase Name}, CONTAINS("Task 2", @cell )))
2. Design Engineer Hours: =IF([Budget:]@row > 0, SUMIFS({TS WIP Incurred Hours}, {TS WIP Project Name}, [Project Name | Helper]1, {TS WIP Phase Name}, CONTAINS("Task 1", @cell ), {TS WIP Category}, "Design Engineer"))

*For the other fee categories (Senior design engineer and Principal #2 above just has design engineer swapped for the appropriate group I am attempting to pull)

For this formula it works for all rows I have applied it to except Row 6. Everywhere else it seems to work but across my sheets there always seems to be just one row that it doesnt work. Additionally I did the math on the sheet I am referencing and there are hours that should be reflected.

Please help!

Paul Newcome

Are you getting an error message or an unexpected number? Are you able to provide a screenshot of the reference sheet entry/entries that should be pulled into the calculation?