Sign in to join the conversation:
Hi
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
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.
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.
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) = ####))
Hi there. I am working on several sheets that have a column called "Hours" which holds an hour estimate for task rows. I'd like for their parent rows to have a sum like "=sum(children())" so I can see how many hours are estimated for each project. My problem is that while I can manually set this for the rows, these sheets…
I am struggling finding a formula to mark the successor task "In Progress" when predecessor is "Complete" like can be done in MPP. I am encouraging my organization to move to SS with the automation, reporting, dashboard and automation capabilities, and away from MPPP so trying to replicate some of the items they utilize in…
HI All, I have a formula that i have got working - only issue i have is I have run out of cross reference "space" and cannot add my last spring to complete my function is there anther way to do this Source sheet OR date UP date Site Target sheet Required date Updated Date Site i need to return source sheet UP date, when OR…
