Sum Reference in another sheet

Good day All:

I am trying to use a SUMIF formula that would allow me to add everything less than 2,000 with multiple status. Here is the formula I am using but I am receiving an invalid operation. what am I missing?

=SUMIFS({A3: Fi TLS Merchant Impact List Range 3}, <2000, {A3: Fi TLS Merchant Impact List Range 2}, "Left Mssg")

I also tried this formula:

=SUMIF({A3: Fi TLS Merchant Impact List Range 3}, <2000, AND({A3: Fi TLS Merchant Impact List Range 2}, "Left Mssg")

Find more posts tagged with

Formulas

Comments

rjudenberg

sumifs requires the following syntax

range, criterion_range1,criterion1,criterion_range2,criterion2

you seem to have forgotten the range of values you wish to sum over.

perhaps you meant this (summ range and criteria1 the same)?

SUMIFS({A3: Fi TLS Merchant Impact List Range 3},{A3: Fi TLS Merchant Impact List Range 3}, <2000, {A3: Fi TLS Merchant Impact List Range 2}, "Left Mssg")

Kal-El

Possibly! I want to sum the range in one column (numbers) but only if it meets my status criteria. For example the formula should only total up only those that are in a left message status.

Kal-El

That formula worked but I do not understand why A3: Fi TLS Merchant Impact List Range 3 is in the formula twice. Shouldn;t it only look at range 3 once and then look for range 2?

Kal-El

Alos if I wanted to add additional statuses would be as simple as adding another Reference such as {A3: Fi TLS Merchant Impact List Range 2}, "No Answer")

Kal-El

I found what I was doing wrong. I appreciate your help!

Sign in to join the conversation!

Quick Links

Trending discussions

Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Issue with automation process reporting a date in a special column
In the Smartsheet sheet “CRS RO Master” we have programmed an automation called “Track Changes in dates, confirmation and LHG code” [PICTURE 1] This one should report a date of a change in the columns “CRS GO LIVE DATE” and “PMS Go LIVE DATE” in the column “. CRS Check date changed”. [PICTURE 2] The update of the “Go live…