Using COUNTIF to find similar keywords then count numbers

[randy2012]

Good morning!

I have an issue with COUNTIF. Here’s the code:

=Countifs(c3:c132,”*4O*”, D3:D132,””<>”&””)

What im trying to accomplish is to count each number IF the name next to the code contains the characters “4O”

Also im trying to create a different code that counts the amount of days that row C column C was updated. The only issue is the dynamic portion where the code changes each time the next block has a newer date. This code is driven By date format and changes each time. For example:

=COUNTIFS(d3:d3,”Date()”)

Or

Amount of days passed during update: 21
11/2/2018. |. 11/31/2018
CONT.
12/3/2018 | 12/23/2018
Amount of days on that persons desk: 20

Simply put, to track the amount of days something was sitting on your desk. And the next persons desk and so forth.

[6StringJazzer]

I have an issue with COUNTIF. Here’s the code:

=Countifs(c3:c132,”*4O*”, D3:D132,””<>”&””)

What im trying to accomplish is to count each number IF the name next to the code contains the characters “4O”

I'm not sure what you are trying to do with column D or that last expression, which is illegal because the quotes don't match. This formula does what you stated here:

=COUNTIF(C3:C132,"*4O*")

Also im trying to create a different code that counts the amount of days that row C column C was updated. The only issue is the dynamic portion where the code changes each time the next block has a newer date. This code is driven By date format and changes each time. For example:

=COUNTIFS(d3:d3,”Date()”)

You have not given nearly enough information for us to understand what you are doing. You refer to dates but don't tell us where they are. What does "next block" mean? What is "the code"? You showed a formula that refers only to a single cell (D3). And what are you trying to do with "Date()"? It is just a string. Do you really want the current date there?

I recommend you attach your file. If data is private then replace with fake data.
Jeff

[randy2012]

Good point.

See attached example.

[JeteMc]

Guessing that you want the first formula placed in B28 on the 'Counting Characters...' sheet, try:

Please Login or Register  to view this content.

Also guessing that the second formula should populate column F on the 'Counting Days...' sheet, try:

Please Login or Register  to view this content.

Note: some of the entries in G6:L10 are text as opposed to dates so those will have to be changed to dates before the second formula will work.
Let us know if you have any questions.