COUNTIF? Use one column as condition to determine average of another

  • Thread starter Thread starter pacman2k4
  • Start date Start date
P

pacman2k4

This may be beyond the scope of basic excel, but here goes.

C4:C16 contains a list of times, or durations in this case.

In D4:D16 each cell contains either a "yes" or "no"

what I would like to do is average the "yes" times. So referenc
D4:D16 as a condition to determine which times to average.

I could just manually seperate the "yes" times and compute the average
but there must be a way to do it as described above
 
This may be beyond the scope of basic excel, but here goes.

C4:C16 contains a list of times, or durations in this case.

In D4:D16 each cell contains either a "yes" or "no"

what I would like to do is average the "yes" times. So reference
D4:D16 as a condition to determine which times to average.

I could just manually seperate the "yes" times and compute the average,
but there must be a way to do it as described above.
Click to expand...
Hi,

=AVERAGE(IF(D4:D16="yes",C4:C16)), to be entered using Ctrl+Shift+Enter

Why do it manually, when you can have Excel do for you? :-)

Hope this helps!
 
Thanks so much!

I had actually tried that same formula, so I was on the right track..
but did not know about the ctrl-shift-enter command, so it wa
returning a "#VALUE".

What does crtl-shift-enter do
 
Back
Top