Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Re: SUNPRODUCT and COUNTIF
1 view
Skip to first unread message
Peo Sjoblom
Jun 6, 2005, 6:17:53 PM6/6/05
to
=SUMPRODUCT(--(Rep_Range="Rep
1"),--(Order_Date_Range=DATE(Year,Month,Day)),--(Part_Range="Part"))
1"),--(Order_Date_Range=DATE(Year,Month,Day)),--(Part_Range="Part"))
--
Regards,
Peo Sjoblom
(No private emails please)
"JerryS" <Jer...@discussions.microsoft.com> wrote in message
news:71F4DE9E-EB90-4FD4...@microsoft.com...
>I want to count the number of times values in three comumns are met. For
> example, column 1 has the rep number, column 2 has the part number and
> column
> 3 has the order date. What would the formula look like that tells me how
> many
> widgets did rep1 sell on a certain day? Thanks
> --
> JerryS
Vasant Nanavati
Jun 6, 2005, 6:22:28 PM6/6/05
to
And hopefully, column 4 has the number of widgets sold.
Something like:
=SUMPRODUCT((A1:A100="Rep001")*(B1:B100="Part1001")*(C1:C100=DATEVALUE("6-Ju
n-2005")*(D1:D100))
--
Vasant
0 new messages