Welcome!

Countif formula to return value for a month

Noemi

How can I count how many times a certain text is present from reports coming in from different dates?

I have to count how many times the text is there monthly. ( the text is a site name visited )

Thank you for your help

Find more posts tagged with

Formulas

Comments

Sinema

I just capture the name

=COUNTIF(Column1:Column1, "Text Capture")

If you are trying to capture text and capture it based on other criteria .. use the COUNTIFS

Is that what your thinking? If it isn't date dependant then you can just grab it by the text.

If I were trying to count how many times Blue was in a column

Name | Colors | Date

A Blue 01-01-2019

B Red 02-02-2019

C Blue 02-01-2019

=COUNTIF(Colors:Colors, "Blue")

I hope that was right I'm multitasking.

Paul Newcome

You would need to use the COUNTIFS to be able to include both the specific text and the date criteria.

=COUNTIFS([Site Name Column]:[Site Name Column], "Site Name", [Date Column]:[Date Column], AND(@cell >= DATE(yyyy, mm, dd), @cell <= DATE(yyyy, mm, dd)))

Where the first DATE function is the starting date of your date range, and the second DATE function is the ending date of the range.

Paul Newcome

You can also pull by looking at the month and year directly.

=COUNTIFS([Site Name Column]:[Site Name Column], "Site Name", [Date Column]:[Date Column], AND(MONTH(@cell) = ##, YEAR(@cell) = ####))

Técnica Engenharia

Sign in to join the conversation!

Quick Links

Trending discussions

COUNTIFS formula across sheets
Hi all I've been using Sheet Summary's to calculate some data which seems to work quite well. For instance this is an example of a Summary that is working fine. (Its an ISO27001 audit tracker sheet) =COUNTIFS(Finding:Finding, "Opportunity for Improvement", Status:Status, <>"COMPLETE", [Agreed closure date]:[Agreed closure…
Sum values from child rows automatically with formula while allowing manual data entry into child row cells
We have a project plan with resourcing allocation built in to it (hours and budget) Currently we have a column for Allocated Hours where we are having to manually enter the below formula into the parent rows. I have figured out a work around by having a secondary column that I have hidden to sum the hours from the child…
Autopopulate Cells Else New Entry
I am trying to create a New Order Entry form. I have a dropdown list that references our customer sheet. If the customer is not listed, you can choose "(NEW CUSTOMER)", which allows more fields to open up to add the new customer info. If the customer is listed, can I have the address autopopulate into the appropriate…