Sum data based on company and date range criteria

  • Thread starter Conditional sum with date range
  • Start date
C

Conditional sum with date range

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

firefytr

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
 
A

Aladin Akyurek

=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
[email protected]> wrote in message
news:[email protected]...
 
Top