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

Ashley Ryder

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

Heather Duff

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

Heather Duff

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

Ashley Ryder

Hi Heather

Thank you so much that appears to do the trick

Much appreciated

Regards

Ashley