polardude1983
New Member
- Joined
- May 6, 2019
- Messages
- 2
Hello All,
I have always appreciated the help that everyone has given here to other people and can usually find the answer that I'm looking for. You are all an amazing community.
What I'm trying to do and I got most of it is find how many "occurrences" an employee has had within the past 30 days. The formula that I have below works but only counts the cells that exactly match C2 and not *C2*.
C2 = "Time and Temp"
With the above formula it calculates that the employee Kathleen has had 3 Time and Temp occurences in the last 30 days. But it should actually be 4. But it's not recognizing the occurence with Time and Temp and goal sheet which would be cell C8.
I have tried using ISNUMBER or SEARCH or Find or combining them or using "*"&C2 but when I do it either counts 0 instances or just comes up as a bad formula.
Here is what I have as my example
[/FONT][/COLOR]
<tbody>
</tbody>
I have always appreciated the help that everyone has given here to other people and can usually find the answer that I'm looking for. You are all an amazing community.
What I'm trying to do and I got most of it is find how many "occurrences" an employee has had within the past 30 days. The formula that I have below works but only counts the cells that exactly match C2 and not *C2*.
Code:
[COLOR=#000000][FONT=Inconsolata]=[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]ARRAYFORMULA[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]([/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]SUM[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]([/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]([/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]([/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]TODAY[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]([/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata])[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]-[/FONT][/COLOR][COLOR=#F7981D][FONT=Inconsolata]B5:B[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata])[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]<=[/FONT][/COLOR][COLOR=#1155CC][FONT=Inconsolata]30[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata])[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]*[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]([/FONT][/COLOR][COLOR=#7E3794][FONT=Inconsolata]C5:C[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]=[/FONT][/COLOR][COLOR=#11A9CC][FONT=Inconsolata]C2[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata])[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]*[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]([/FONT][/COLOR][COLOR=#A61D4C][FONT=Inconsolata]A5:A[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]=[/FONT][/COLOR][COLOR=green][FONT=Inconsolata]"Kathleen"[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata])[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata])[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata])
C2 = "Time and Temp"
With the above formula it calculates that the employee Kathleen has had 3 Time and Temp occurences in the last 30 days. But it should actually be 4. But it's not recognizing the occurence with Time and Temp and goal sheet which would be cell C8.
I have tried using ISNUMBER or SEARCH or Find or combining them or using "*"&C2 but when I do it either counts 0 instances or just comes up as a bad formula.
Here is what I have as my example
[/FONT][/COLOR]
A | B | C | |
5 | Kathleen | 4/9/2019 | Time and Temp |
6 | Jim | 4/10/2019 | Time and Temp |
7 | Kathleen | 4/10/2019 | Time and Temp |
8 | Kathleen | 5/4/2019 | Time and Temp Goal Sheet |
9 | Jim | 5/6/2019 | Tool 2 |
10 | Kathleen | 5/8/2019 | Time and Temp |
11 | Jim | 5/9/2019 | Time and Temp |
12 | Jim | 5/10/2019 | Time and Temp |
<tbody>
</tbody>