Thread: How do I get it to sort Criteria in A1:A6 and B1:B6 if both are c.
View Single Post
  #1   Report Post  
C Cooper Midland
 
Posts: n/a
Default How do I get it to sort Criteria in A1:A6 and B1:B6 if both are c.
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

Reply With QuoteReply With Quote