SUMIFS using 3 criteria

John Littler
John Littler ✭✭✭✭
edited 05/06/21 in Formulas and Functions

Hi...I need help with a formula, I need to sum a value by lane based on a monthly date. I feel I have the date portion correct but not getting the sum part? I need the front end of the formula...

AND(IFERROR(MONTH(@cell), 0) = 4, IFERROR(YEAR(@cell), 0) = 2021))

@Paul Newcome @Sue Hill @Kimberly Loveless

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!