F
Frustrated
I have two spreadsheets. SSA stores Bushels of grain
stored and the date they were stored. Columns are:
DateStored Bushels.
1/1/03 325
5/15/03 3256
9/15/03 2531
SSB lists the date and the cash price of grain. Columns
are:
Date Price Bushels On Hand
2/1/03 5.25
6/12/03 7.25
10/1/03 7.09
In SSB I would like to have a column with a cell for each
date that would run a sumif function that looks at the
price date and sum the quantity of grain stored on or
before that date. I've tried the following formula but to
no avail.
=sumif('SSA'!A2:A4,<='SSB'!C2,'SSA'!B2:B4)
Something tells me the <= in the criteria statement is the
problem but...any ideas?
Thanks in advance.
Greg
stored and the date they were stored. Columns are:
DateStored Bushels.
1/1/03 325
5/15/03 3256
9/15/03 2531
SSB lists the date and the cash price of grain. Columns
are:
Date Price Bushels On Hand
2/1/03 5.25
6/12/03 7.25
10/1/03 7.09
In SSB I would like to have a column with a cell for each
date that would run a sumif function that looks at the
price date and sum the quantity of grain stored on or
before that date. I've tried the following formula but to
no avail.
=sumif('SSA'!A2:A4,<='SSB'!C2,'SSA'!B2:B4)
Something tells me the <= in the criteria statement is the
problem but...any ideas?
Thanks in advance.
Greg