SUMIF error

Lauren Dobkin

Lauren Dobkin ✭✭

09/13/22 in Formulas and Functions

I'm stumped on another formula. I receive an "incorrect argument set"

Total [Dave Delivered] if the month is January

=SUMIF([Actual Date Completed]3:[Actual Date Completed]46, MONTH(@cell) = 1, [Dave Delivered]3:[Dave Delivered]40)

Screen Shot 2022-09-13 at 12.02.37 PM.png

Thank you

Tags:

Formulas

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

09/13/22 edited 09/13/22

Your ranges need to match in size and shape. It looks like one is rows 3 - 46 and the other is rows 3 - 40.

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter
Unknown

11/30/22

This content has been removed.

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Need an equation to count text from a column with multiple selections
I'm having the issue of getting an equation to work properly in order to get a count on text in a drop down list of items. For example: I need to count how many times "Electrical" or "Paint" is mentioned in the same cell for the whole column. I keep getting error messages. The only equation that I could get to work would…
Forumula help to extra characters from a cell
Morning I am hoping someone has an idea how I can achieve the following I have a barcode which is formatted like this when scanned into Smartsheet (01)00843997014755(11)240401(21)700040293 What I need for example is when the barcode is scanned into lets say cell A, then automatically cell B,C and D will extra data from…
Index Collect partially working
I am trying to validate information using Index Collect function. It works when I look at the school's name, but when I add the 2nd criteria for the school district, I get the #Incorrect Argument Set error. SCID=the ID number SN is school Name in the criterion range DN is the district name in the criterion range…