Sum data based on company and date range criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking for help in creating an equation to sum numbers within a column
based on company name and a date range. For instance, calculate the cases of
product B sold to company A between the month X and month Y or Year X and
Year Y.
 
Hello,

If your company names were in column A, and your dates were in colum
B, and the numbers you wanteed summed were in column C, maybe you coul
use something like this ...

=SUMPRODUCT(--(A1:A10="Company Name"),--(B1:B10<"en
date"),--(B1:B10>"start date"),C1:C10
 
=SUMPRODUCT(--(DateRange>=DATE(F2,E2,1)),--(DateRange<=DATE(H2,G2,1)),--(ProductRange=I2),DollarRange)

where E2 houses a month number, F2 a year, G2 a month number which is >= E2,
H2 a year which is >= F2, and I2 a product.

"Conditional sum with date range" <Conditional sum with date
(e-mail address removed)> wrote in message
news:[email protected]...
 
Back
Top