rushthecourt
New Member
- Joined
- Jul 8, 2007
- Messages
- 35
Hello again -
I've almost gotten my database where I want it, thanks to much of your assistance the last couple of weeks. I very much appreciate it.
As I was auditing some formulas today, I came across an oversight that has to do with my averaging formulas.
I have a formula like this:
=AVERAGE(IF($C$4:$C$4995="x",$K$4:$K$4995))
This formula's problem is that it is not accounting for instances where there is an X in column C, but K is blank. The excel sheet is averaging K in that instance as if it had a "0" within.
Another example is this:
=AVERAGE(IF($C$4:$C$4995="x",IF($H$4:$H$4995<0,$o$4:$o$4995)))
Again, any time there is an X in column C & H>0, it is averaging every according cell in column o - including those that are blank. It should only be averaging those with a value in column o (fitting the two criteria of course).
Thanks again for all your help!
RTC
I've almost gotten my database where I want it, thanks to much of your assistance the last couple of weeks. I very much appreciate it.
As I was auditing some formulas today, I came across an oversight that has to do with my averaging formulas.
I have a formula like this:
=AVERAGE(IF($C$4:$C$4995="x",$K$4:$K$4995))
This formula's problem is that it is not accounting for instances where there is an X in column C, but K is blank. The excel sheet is averaging K in that instance as if it had a "0" within.
Another example is this:
=AVERAGE(IF($C$4:$C$4995="x",IF($H$4:$H$4995<0,$o$4:$o$4995)))
Again, any time there is an X in column C & H>0, it is averaging every according cell in column o - including those that are blank. It should only be averaging those with a value in column o (fitting the two criteria of course).
Thanks again for all your help!
RTC