How do I get it to sort Criteria in A1:A6 and B1:B6 if both are c.

C

C Cooper Midland

It's me again!
Spread Sheet Column A = New or Repeat
Column B = date
Column C = Number of guests
What I need is:
If A1:A6 = New AND B1:B6 >= 10/01/2004 THEN Sum C1:C6
 
P

Peo Sjoblom

One way

=SUMPRODUCT--(A1:A6="New"),--(B1:B6>=DATE(2004,10,1)),C1:C6)


Regards,

Peo Sjoblom
 
Top