Hello,
I have a table with many dates, and I'd like to get the average NETWORKDAYS between various dates. However, I need to exclude rows in which column C is blank.
sampleexcel.PNG
In this example, I know that the answer I'm looking for is 50 days, and the obvious solution would be to use a helper column. However, I'd like to avoid that a) because the real data has a lot more data and would need many helper columns, and b) I'm trying to increase my Excel knowledge. I've been playing around with arrays for the first time, but not succeeding in finding a solution to this.
Thanks!
Edit: I should add that I'm working primarily in Google Sheets, where I was able to use
to get a result of 50, but when I expand it to include row 4, I get bad data (large negative number) because of the blank.HTML Code:
Bookmarks