How do I set up conditional formulas

C

craig

I have standard 2003. Does it allow me to do "F2, Ctrl+Shift+Enter" or is
that just in the pro version. Here is the formula I am trying
=SUM(IF(($A$10:$A$200="F")*($H$10:$H$200=2),$G$10:$G$200))+F4
 
B

Biff

Hi!

You can enter an array formula in any version. However, you can accomplish
the same thing without an array formula. Try this:

=SUMPRODUCT(--($A$10:$A$200="F"),--($H$10:$H$200=2),$G$10:$G$200)+F4

It's better to use cells to hold the criteria:

A1 = F
B1 = 2

=SUMPRODUCT(--($A$10:$A$200=A1),--($H$10:$H$200=B1),$G$10:$G$200)+F4

Biff
 
Top