Hello group. I have search throughout the forum and have found many threads with this type of question, however, I didn't find one that I could get to work for my needs. I am not sure if MEDIAN or AGGREGATE or another option is the best answer. I hope the following combined with the attached file might explain what I am attempting to calculate.
NOTES:
- Using Excel 2016
- Cell H3 is the cell I'm experimenting with to use both IF and AND
- Cells I3, I4, H4 are all working properly with just the IF
- I'm using CSE (Array)
- If column A is empty, the associated numbers in column C & D should be counted in the totals
- In column B, only count the associated numbers in column C & D only if Done
Please see the attached file for a sample. Thank you in advance!!
AiPnIt
Bookmarks