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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I get it to sort Criteria in A1:A6 and B1:B6 if both are c. (https://www.excelbanter.com/excel-discussion-misc-queries/1881-how-do-i-get-sort-criteria-a1-a6-b1-b6-if-both-c.html)

C Cooper Midland

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

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

--
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

Peo Sjoblom

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

All times are GMT +1. The time now is 04:03 PM.