software

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

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=quot;Fquot;),--($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

quot;craigquot; gt; wrote in message
...
gt;I have standard 2003. Does it allow me to do quot;F2, Ctrl Shift Enterquot; or is
gt; that just in the pro version. Here is the formula I am trying
gt; =SUM(IF(($A$10:$A$200=quot;Fquot;)*($H$10:$H$200=2),$G$10: $G$200)) F4