How do I get it to sort Criteria in A1:A6 and B1:B6 if both are 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

 

[Frank Kabel]

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

Also see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[Peo Sjoblom]

One way

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


Regards,

Peo Sjoblom