Hello,
This seemingly simple formula creation has been driving me nuts. Please help if you can.
Referencing the attachment, I am trying to create a formula for cell G5 and G6 that counts up the absolute number of calendar days from column C.
The challenge for me has been that the count has to be broken down by the two different "Systems" named in column B (CLCN 1 and CLNC 2).
Also, there are duplicate dates for each of the two different systems listed in column B.
I have tried various combos using functions to include IF, COUNTIF, SUM, AND, MATCH, FREQUENCY, and FILTER, but to no avail.
Any suggestions? Thanks.
Bookmarks