Formula to get data to perform calculation starting at row 4000 downwards


Hi I am a bit of a novice with smart sheet formulas but hoping soemone can help i am using the formula below

=COUNTIF(Status:Status, "Enquiry")

This totals the number of enquiries we recieve which works fine but i would now like to create a formula which starts at specific row number - example row 4000 which is the first enquiry we had this year and return the total from that point not the entire sheet - can anyone help with this please



Best Answer

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Answer ✓

    Hi Ashley,

    If you have a date column, you could try this:

    =countifs(Date:Date, >date(2020, 12, 31), status:status, "Enquiry")

    This counts all rows with the status as "Enquiry" with a date that is later than December 31 2020.

    Hope this helps!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!