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).


=SUMIFS({balance}, {A1}, HAS(@cell, "[email protected]"), OR({a2}, HAS(@cell, "[email protected]")), OR({a3}, HAS(@cell, "[email protected]")), OR({a4}, HAS(@cell, "[email protected]")), OR({a5}, HAS(@cell, "[email protected]")), OR({a6}, HAS(@cell, "[email protected]")), {a7}, {invoice date}, <TODAY())

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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!