98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » COUNTIF
COUNTIF
Resolved · Medium Priority · Version 2010
Fri 21 Jul 2017, 14:51Delegate Hannah said...
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
Mon 24 Jul 2017, 11:13Trainer Wendy said...
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
Mon 31 Jul 2017: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Removing border lines on the keyboardHighlight your cell(s) that have boreders on them and press CTRL + SHIFT + _, this will then remove the border lines. |
