Issues with multiple Sumifs statements

Christy Kooiman

I can't get this formula to work...any thoughts?

=SUMIFS([Hours/Week]:[Hours/Week],[X Project Status]:[X Project Status], "Active", [Assigned to]:[Assigned to], "Employee Name", Type:Type, <>"Admin") + SUMIFS([Hours/Week]:[Hours/Week],[Y Project Status]:[Y Project Status], "Active", [Assigned to]:[Assigned to], "Employee Name", Type:Type, <>"Admin")

Christy Kooiman

I'm not sure what happened but I actually deleted my formula, got out of smartsheets copied it back in and it took it this time. Odd but it's working now.

Paul Newcome

Are you getting an error or the incorrect number?

Christy Kooiman

@Paul Newcome I'm getting #Unparsable

Paul Newcome

Can you provide a screenshot of the formula actually in the sheet (opened up as if you are about to edit it)?

Christy Kooiman

I'm not sure what happened but I actually deleted my formula, got out of smartsheets copied it back in and it took it this time. Odd but it's working now.