Sumproduct;3 criteria
Try the below
=SUMPRODUCT(('May YTD Data'!$K:$K="New Customer")*
('May YTD Data'!$AB:$AB=B6)*
(TEXT('May YTD Data'!$D:$D,"mmmyyyy")="May2010"),'May YTD Data'!$Q:$Q)
"GregL" wrote:
Hello,
I need a formula that will sum the dollar value of a column if the entries
meet 3 seperate criteria.
The current formula I have (that returns a #NUM error) is:
=SUMPRODUCT(('May YTD Data'!$K:$K="New Customer"),('May YTD
Data'!$AB:$AB=B6),('May YTD Data'!$D:$D4/30/2010),('May YTD
Data'!$D:$D6/1/2010),'May YTD Data'!$Q:$Q)
Idea is to sum the sales volume (dollar amount) for "New Customer" per sales
reps (B6) for the month of May.
Thanks in advance for any advice you provide
|