Can't figure out my issue with SUMIF

Brenda Fraser

I'm certain I'm doing something wrong, but I can't figure it out. I'm trying to sum total revenue per Engagement Manager. I can get the total SUM and the COUNT of EMs, but not combined.

=SUMIF({Drawdown Services Total},({Drawdown Services EM},=[Primary Column]@row))

Thanks for your help!

Jennifer Kurtz

Hi Brenda—

If you're trying to sum the "Drawdown Services Total" based on Primary Column@row, then i think you just need to put the ranges above in a different order:

SUMIF({your criteria range}, [criteria], {Range you want to sum}

Given your response above, i think this means:

=SUMIF({Drawdown Services EM}, [Primary Column]@row, {Drawdown Services Total})

Feel free to post a screenshot of your columns if we're still not getting it! :)

Paul Newcome

Your syntax is wrong for the SUMIF function, and you don't need that extra set of parenthesis.

=SUMIF({criteria Range}, Criteria, {Sum Range})

Brenda Fraser

Thanks for your quick response. When I removed the extra parenthesis, instead of #UNPARSEABLE, I get #INCORRECT ARGUMENT SET.

=SUMIF({Drawdown Services Total}, {Drawdown Services EM}, [Primary Column]@row)

Could it be something with the way I'm referencing the other sheet?

dojones

I think your criteria is out of order.

=SUMIF({criteria Range}, Criteria, {Sum Range})

=SUMIF({Drawdown Services Total}, {Drawdown Services EM}, [Primary Column]@row)

Try this

=SUMIF({Drawdown Services Total}, [Primary Column]@row, {Drawdown Services EM})

Brenda Fraser

Thanks for the response! That parses but maybe I'm not clear in what I'm trying to do:

=SUMIF({Drawdown Services Total}, [Primary Column]@row, {Drawdown Services EM})

^ this is the revenue I'm trying to sum

^ criteria when [Primary Column]@row is found in {Drawdown Services EM}

This is considering the final parameter the Sum Range and not part of the Criteria.

When I add the paranthesises around the 2 parameters, I get an unparse error.

Paul Newcome

Double check the order you have each part in. The correct order is in my last post. The range to sum should be the last part of a SUMIF function.

Jennifer Kurtz

Hi Brenda—

If you're trying to sum the "Drawdown Services Total" based on Primary Column@row, then i think you just need to put the ranges above in a different order:

SUMIF({your criteria range}, [criteria], {Range you want to sum}

Given your response above, i think this means:

=SUMIF({Drawdown Services EM}, [Primary Column]@row, {Drawdown Services Total})

Feel free to post a screenshot of your columns if we're still not getting it! :)

Brenda Fraser

That worked!!! Thanks so much!

I don't know why I was so confused about the criteria.

Paul Newcome

Happy to help. 👍️

Jennifer Kurtz

Awesome - so glad you got it working! Happy Friday :)