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

Thanks


Ashley

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!

    Best,

    Heather

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!