array question

  • Thread starter Dr. Harvey Waxman
  • Start date
D

Dr. Harvey Waxman

=AVERAGE(IF($C$12:$C$7858<=K3,$S$12:$S$7858))
=AVERAGE(IF(($C$12:$C$7858>K3)*($C$12:$C$7858<=K4),$S$12:$S$7858))

These work as expected but I'd like to SUM the entries that satisfy the IF
statement not average them. And the SUMs I'd like are in the C range itself
not the S range.

I can't seem to bend this to do what I want. Should I use some other strategy?
Ideas?

Thanks

Harvey
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top