In the attached WB, I would like to find RESULTS!C26, but also conditioning for only if Table1[STOP] is <>
I've tried the following, but doesn't work...
Please Login or Register to view this content.
In the attached WB, I would like to find RESULTS!C26, but also conditioning for only if Table1[STOP] is <>
I've tried the following, but doesn't work...
Please Login or Register to view this content.
Last edited by cableghost; 01-01-2022 at 01:23 PM.
I cut your data back a lot to facilitate manual checking:
=SUMPRODUCT(((Table1[DATE]<>"")*(Table1[STOP]<>""))/COUNTIFS(Table1[DATE],Table1[DATE]&""))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thank you! I don't follow the logic in the formula, but whatever works
On the cut back version, use formulas/evaluate formula to see it step by step. If you're still baffled... shout and I'll explain it.
I couldn't understand the steps in the evaluation approach. I feel I understand the conditioning of the dates via ((Table1[DATE]<>"")*(Table1[STOP]<>"")), but then how does the formula know how many to divide by? I see you changed COUNTIF to COUNTIFS.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks