Re: formulas

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

=SUMPRODUT(--(D2:D200=11),--(N2:N200<=--"2006-04-25"))

for prior to 25th April, > for after (you will have to decide where the =
goes.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Terri" <Terri@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8141D4A2-90FD-4FF7-B898-0AD7F3C0467F@xxxxxxxxxxxxxxxx
I am attempting to get results from the following spread***:

Column D Column N
Product No. Date Sold
11 4/15/04
11 5/15/04
11 9/30/04
18 2/22/04
18 7/4/04
18 8/28/04

I have the total number of product no. 11 sold. From the above data I
need
to find out how many of Product No. 11 was sold prior to 5/25/04 and how
many
were sold after 5/25/04. I've tried COUNTIF, SUM(IF), COUNT(IF),
SUMPRODUCT
as array formulas and not. Any assistance would be appreciated.


.

Quantcast