Count multiple columns

  • Thread starter Thread starter Peggy
  • Start date Start date
P

Peggy

Not sure how to explain, hope this works:

Is there a way to count cells of data and dates in
multiple columns for example:

Count all in column A that contain apples AND column B
that contain oranges AND column C that 12/31/2003 <>
4/1/2004

A B C
apples grapes 1/1/2004
apples oranges 3/1/2004
apples oranges 5/1/2004

SUM should equal - 1
 
Hi Peggy,

try,

=SUMPRODUCT((A1:A3="apples")*(B1:B3="oranges")*(C1:C3>DATE(2003,12,31))*(
C1:C3<DATE(2004,4,1)))

Adjust your ranges accordingly.

Hope this helps!
 
Hi
try
=SUMPRODUCT(--(A1:A100="apples"),--(B1:B100="oranges"),--
(C1:C100>=DATE(2004,1,1)),--(C1:C100<DATE(2004,4,1)))
 
Back
Top