Sum column data when a employee type is selected

Question

I am building a separate report referencing a sheet.

When a specific employee type is selected:

* Freelancer

I want to to sum the numbers in these 3 columns

* Copy3pp
* Copy edit fl
* copy proof fl

For a particular week.

* In my report the Primary column is the week # 1-52
* In sheet referencing I have a column called Week (weekof) in the formula below

=IF(CONTAINS({copywriterfl}, Freelancer), SUMIFS({Weekof}, =[Primary Column]@row, {Copy3pp}), SUMIFS({Weekof}, =[Primary Column]@row, {Copyeditfl}), SUMIFS({Weekof}, =[Primary Column]@row, {Copyprooffl}))

I get error unparseable.

I tried this as well: I got the same error unparseable

=IF(CONTAINS({copywriterfl}, Freelancer, SUMIFS({Weekof}, =[Primary Column]@row, {Copy3pp}, {Copyeditfl}, {Copyprooffl}))

Pam Dunn · Answer

Bassam,

Thank you for your reply, but I am confused by your reply.  I had provided this formula which I haven't been able to get to work.

My original formula

=IF(CONTAINS({copywriterfl}, Freelancer), SUMIFS({Weekof}, =[Primary Column]@row, {Copy3pp}), SUMIFS({Weekof}, =[Primary Column]@row, {Copyeditfl}), SUMIFS({Weekof}, =[Primary Column]@row, {Copyprooffl}))

You replied with the following formula, the only difference I saw was adding quotes " " around Freelancer.  Comparing the two formulas I did not see any difference between the parenthesis in my original formula and the one you provided.  I added the quotes, but the formula still does not work.

Your proposed new formula

=IF(CONTAINS({copywriterfl}, "Freelancer"), SUMIFS({Weekof}, =[Primary Column]@row, {Copy3pp}), SUMIFS({Weekof}, =[Primary Column]@row, {Copyeditfl}), SUMIFS({Weekof}, =[Primary Column]@row, {Copyprooffl}))

Bassam Khalil · Answer

@Pam Dunn

Please check the "Freelancer" in your formula I didn't see the ""    ""

Pam Dunn · Answer

@Bassam Khalil ,

Thank you for your response,.

Your answer is exactly like my first formula that didn't work except for adding quotes around Freelancer.  I added the quotes around Freelancer, but it is now coming back as Incorrect Argument.