Average If problem (again)
Posted by Tanya on December 10, 2001 3:06 PM
I posted this question before, but the response I received didn't work. I'm thinking that maybe I wasn't very clear, so I want to try it again.
As an example, let's say I have a worksheet with the following:
Column A - contains dates
Column B - a number that comes from a vlookup function
Column C - #days derived from networkdays function
I need a formula to solve the following problem:
Average Column C if Column A is null AND Column B ="10"
Will probably need an array formula, but I haven't had much success at creating one that actually works. I would appreciate any help that I could get.