Count within last 30 days if a specified value

Oscar Maynard

Hi!

Could someone offer me some help with my formula below please?

I need to count how many rows have a date within the last 30 days in column 'Timestamp', and have a value above 8 in column 'NPS', and have a certain name in column 'Centre':

=COUNTIFS({Feedback mastersheet Range 1}, <=TODAY(30), {Feedback mastersheet Range 2}, >8, {Feedback mastersheet Range 3}, "CENTRE NAME HERE")

This is being used in a secondary sheet, hence the references back to the mastersheet.

Would be really grateful for any help! :)

Thanks

Oscar

Leibel S

@Oscar Maynard

I believe the below is what you are looking for:

=COUNTIFS({Feedback mastersheet Range 1}, AND(@cell <= TODAY(), @cell >= TODAY(-30)), {Feedback mastersheet Range 2}, @cell>8, {Feedback mastersheet Range 3}, "CENTRE NAME HERE")

Leibel S

@Oscar Maynard

I believe the below is what you are looking for:

=COUNTIFS({Feedback mastersheet Range 1}, AND(@cell <= TODAY(), @cell >= TODAY(-30)), {Feedback mastersheet Range 2}, @cell>8, {Feedback mastersheet Range 3}, "CENTRE NAME HERE")

Oscar Maynard

https://community.smartsheet.com/discussion/comment/327576#Comment_327576

That seems to work! Thank you so much, that's so helpful!