Formulas: Reference Data from Other Sheets

Good afternoon Smartsheet Community:

I am trying to add the total from the count of 2 sheets given the criteria. However, I am receiving an INCORRECT ARGUMENT SET when using SUM or Count conditions (formula below).

Any help appreciated, Thanks!

=SUMIFS({A9: PayChex TLS Impact List Range 1}, "Need A File Build", {A2: ALL Other Merchant TLS Impact List Range 1}, "Need A File Build")

Find more posts tagged with

Formulas

Comments

Jim Hook

Kal-El, I think you should be using the COUNTIFS function to count the number of "Need A File Build" occurrences in a range of cells. I think the formula below would work:

=COUNTIFS({A9: PayChex TLS Impact List Range 1}, "Need A File Build") + COUNTIFS({A2: ALL Other Merchant TLS Impact List Range 1}, "Need A File Build")

The first COUNTIFS will count the number of occurrences of "Need A File Build" on the first sheet and the second will count the number of occurrences of "Need A File Build" on the second sheet and they get added together.

Kal-El

Thanks, I stepped away from it yesterday and when I came back it clicked on what I was doing wrong. However, I really appreciate your reply helping me with this formula.

Have a Blessed Day!

Sign in to join the conversation!

Quick Links

Trending discussions

Dropdown list restrictions
Is there a way to limit a dropdown list so that the values in the dropdown list can only be used once in a column?
seeking VLOOKUP or equivalent, search for most recent value, multiple dropdowns
My product/use case: I seek to build a camera inventory. Each camera has a unique identifier. Cameras are mobilized to different locations on different days. I need help making a VLOOKUP or equivalent combination of formulae functions to run 2 queries cross-referencing 2 grids, searching a column with multiple dropdown…
Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet