Count multiple columns

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
 
D

Domenic

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

Frank Kabel

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can you replace specific characters in a string ? 2
Counting text in two different columns 2
min in a subgroup 9
Macro to add numbers in a text string 5
match, lookup two column data 10
retrieve & count text 5
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1
Count words in a date sheet 3

Top