Using COUNTIFS Formula

jtomeaCH ✭✭
edited 06/22/23 in Formulas and Functions

Is there a way to use the COUNTIFS function (or another function) like the SUMIFS? I have this one working perfectly:

=SUMIFS({OM Book Date}, {OM Total Sell}, AND(@cell >= DATE(2023, 6, 1), @cell <= DATE(2023, 6, 30)))

Now I need it to count OM Total Sell (some are blank, I need it to count only the ones that have numbers in them) for orders that were booked within the same time frame.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!