Excel problem - sumif with multiple parameters
 

I have 3 columns of data.
The first contain a list of start dates, the second a list of end dates, and
the third a list of numbers.
I want to create a table as follows:
I enter my one start date. This only looks at the rows where this start date
corresponds with my start date. I then use sumif to get the sum amounts on
every end date for that particular start date. I can do the sumif bit, howver
i only want it to sumif the second and third columns where the start dates
match my original start date.

Can you help?

e.g
Start Date End Date Number
June August 10
June September 12
June August 4
August September 5

I want to achieve the following
Start Date End Dates July August September
June 14 12
I can sumif on columns 2 and 3, but only want to do this if the first column
has the correct value as i the example above
Hope this is clear

Excel problem - sumif with multiple parameters
 

=SUMPRODUCT(--(Sheet1!$A$1:$A$10=$A2),--(Sheet1!$B$1:$B$100=B$1),Sheet1!$C$1:$C$100)

--
__________________________________
HTH

Bob

"athletico" wrote in message
...
I have 3 columns of data.
The first contain a list of start dates, the second a list of end dates,
and
the third a list of numbers.
I want to create a table as follows:
I enter my one start date. This only looks at the rows where this start
date
corresponds with my start date. I then use sumif to get the sum amounts on
every end date for that particular start date. I can do the sumif bit,
howver
i only want it to sumif the second and third columns where the start dates
match my original start date.

Can you help?

e.g
Start Date End Date Number
June August 10
June September 12
June August 4
August September 5

I want to achieve the following
Start Date End Dates July August September
June 14
12
I can sumif on columns 2 and 3, but only want to do this if the first
column
has the correct value as i the example above
Hope this is clear

Excel problem - sumif with multiple parameters
 

Let's say your data is in A1:C100

And these entries start in D1
D1 E1 F1 G1 H1
Start Date End Dates July August September
June 14 12

In F2 use =SUMPRODUCT(--($A$1:$A$100=D2),--($B$1:$B$100=F$1),$C$1:$C$100)
Copy this across the row

For more on Sumproduct:
For more details on SUMPRODUCT
Bob Phillips
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
J.E McGimpsey
http://mcgimpsey.com/excel/formulae/doubleneg.html

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"athletico" wrote in message
...
I have 3 columns of data.
The first contain a list of start dates, the second a list of end dates,
and
the third a list of numbers.
I want to create a table as follows:
I enter my one start date. This only looks at the rows where this start
date
corresponds with my start date. I then use sumif to get the sum amounts on
every end date for that particular start date. I can do the sumif bit,
howver
i only want it to sumif the second and third columns where the start dates
match my original start date.

Can you help?

e.g
Start Date End Date Number
June August 10
June September 12
June August 4
August September 5

I want to achieve the following
Start Date End Dates July August September
June 14
12
I can sumif on columns 2 and 3, but only want to do this if the first
column
has the correct value as i the example above
Hope this is clear