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

Create Sequential, Unique ID for certain rows as column formula
I need a column formula that can add sequential, unique IDs to data like this coming in from a form: Task Type Task ID Manual M001 Automated Manual M002 Manual M003 Manual M004 Automated Manual M005 Task IDs that aren’t the manual type need sequential numbering within their type (i.e. A001, A002, etc). Here’s the kicker:…
SUMIFS keeps returning 0
I'm trying to display a sum of the column Total Funds Available when Status = Apps Open, and Value Score = 5. Here is the formula I have: =SUMIFS([Total Funds Available]:[Total Funds Available], Status:Status, ="Apps Open", [Value Score]:[Value Score], ="5") There are rows that meet these conditions and should display a…
Track duration in hrs?
Hi everyone. We have an upcoming project is very short, but very critical, and requires that we track not only the start and end dates, but also the start and end times. Currently our team has added two columns, start time & end time, and they would like to add a duration column that can track the planned duration in…