Good afternoon Grey

There is a way to do this but we'll have to utilise arrays to do so.
The example below assumes that your data containing conditions is in
column A and B and your data to sum is in column C. My assumtion is
that your data covers 50 rows.

=SUM(IF($A$1:$A$50="January",IF($B$1:$B$50="a",$C$ 1:$C$50,0),0))

As it's an array formula don't forget to use Ctrl + Shift + Enter to
commit it (not just Enter on it's own).

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=391795