Domenic - help!

[rushthecourt]

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

 

[barry houdini]

You can try adding an extra criterion, e.g.

=AVERAGE(IF($C$4:$C$4995="x",IF(ISNUMBER($K$4:$K$4995),$K$4:$K$4995)))

and similarly for your second formula