Need help with sumifs statement

Ron Anderson
Ron Anderson ✭✭✭✭
edited 10/24/22 in Formulas and Functions

I am trying to sum a column in a sheet if one of seven cells contain a matching text string. It is bombing out and I am stuck. The last criteria is to limit the invoice amounts summed to those that are overdue (date before today).

Formula

=SUMIFS({balance}, {A1}, HAS(@cell, "alia.bostaji@colliers.com"), OR({a2}, HAS(@cell, "alia.bostaji@colliers.com")), OR({a3}, HAS(@cell, "alia.bostaji@colliers.com")), OR({a4}, HAS(@cell, "alia.bostaji@colliers.com")), OR({a5}, HAS(@cell, "alia.bostaji@colliers.com")), OR({a6}, HAS(@cell, "alia.bostaji@colliers.com")), {a7}, {invoice date}, <TODAY())

Note, A1=agent 1 email, A2 = agent 2 email, etc.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!