One way:

=SUMPRODUCT(--(A1:A300=gr_num),--(C1:C300=DATE(2007,04,19)),X1:X300)

In article ,
Charlie7805 wrote:

I'm using the following in another cell which works fine.
=SUMPRODUCT (($A$4:$A$300=36)*($B$4:$B$300="SALE")*($G$4:$G$30 0="Rob"))

I'm trying to create another formula where column A has group numbers,
column C has dates, column X has costs...I need to sum all cost where columns
A & C are true. How do I handle dates with this formula.

Thanks in advance

C.