| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 -- Regards Frank Kabel Frankfurt, Germany C Cooper Midland wrote: 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 |
|
#3
|
|||
|
|||
|
One way
=SUMPRODUCT--(A1:A6="New"),--(B1:B6=DATE(2004,10,1)),C1:C6) Regards, Peo Sjoblom "C Cooper Midland" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
