Countifs for cells containing a letter

Timothy Schipper

Hello, I have a formula to count how many hours of work I have assigned to me in a given week. It has the following inputs: "Owner" and "1st day of week" and it looks in a different sheet for all rows that meet that criteria and returns the estimated hours for the tasks.

My formula is below and I want a solution for the last segment of it (in bold). I would like all the lines that contain "T" but it is possible that there is more than 1 tag in that given column.

=SUMIFS({01 Project Schedule Phase by Estimated hours}, {01 Project Schedule Phase by Assigned to}, Owner@row , {01 Project Schedule Phase by Start Date}, >=[1st day of the week]5, {01 Project Schedule Phase by Start Date}, <=([1st day of the week]5 + 6), {01 Project Schedule Phase by B Code}, ="T")

Ray Lindstrom

Hi @Timothy Schipper,

I would try replacing the bold text with:

{01 Project Schedule Phase by B Code}, CONTAINS("T", @cell )

You will still need that final ) on the end, so the end of your formula will have two )).

So, basically this:

=SUMIFS({01 Project Schedule Phase by Estimated hours}, {01 Project Schedule Phase by Assigned to}, Owner@row , {01 Project Schedule Phase by Start Date}, >=[1st day of the week]5, {01 Project Schedule Phase by Start Date}, <=([1st day of the week]5 + 6), {01 Project Schedule Phase by B Code}, CONTAINS("T", @cell))

Let me know how it works out.

BRgds,
-Ray