Sum data based on company and date range criteria

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.
 
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
(e-mail address removed)> wrote in message
news:[email protected]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
SUM a range of sales based on month 9
SUM WITH MULTIPLE CRITERIA 3
SUM conditioned to range 6
Changing Sum Range Based on Date Chosen from Drop Down List 1
[CSE] SUM Array Formula with if condition 1
SUM multiple criteria 1
Find last date of sold stock and sold price. 2

Top