Hannah has attended:
Excel Dashboards for Business Intelligence course
COUNTIF
Hi,
I have a set of data. I want to count how many records within my data sat have:
- "continuing" as the status in column c
and
- has a date in column U that is before today's date
I am struggling to construct the formulae, are you able to help? (I use google sheets not excel)
Many thanks,
Hannah
RE: COUNTIF
Hi Hannah
You're looking for the COUNTIFS function.
The COUNTIFS function is covered in the Excel Advanced Formulas and Functions course. The COUNTIFS function will automatically count any reference that matches the multiple criteria values you set.
In column A we have the data containing the phrase "Continuing" and in column B we have dates listed.
The COUNTIFS will select the range and then the criteria value. We then add a second criteria that references Column B and checks if any of the values are before or equal to today
=COUNTIFS(A1:A28,"continuing",B1:B28,"<="&TODAY())
Hope that helps
Kind regards
Wendy
