IF AND SUM?

jb@59069

Hello, I need some help here, please.

I need to check the value of a text column and a checkbox column, then SUM another column based on the results.

Here's what I think it should be but am getting "#UNPARSEABLE":

=IF(AND([Project/Event]:[Project/Event], ="C2 NRM", [Billable?]:[Billable?], =0), SUM[Time Worked]:[Time Worked])

I have also tried:

=IF(AND(SUM[Time Worked]:[Time Worked]), [Project/Events]:[Project/Events], ="C2 NRM", [Billable?]:[Billable?], =0)

Obviously I'm missing something.

Thank you.

SmSulli

I think you'll want to try SUMIFS function.

=SUMIFS([Time Worked]:[Time Worked], [Project/Events]:[Project/Events], "C2 NRM", [Billable?]:[Billable?], 1)

 

Good Luck

Shawn