=SUMPRODUCT((cellsincolumnB=66)*(MONTH(cellsincolu mnA)=1))

for January.

First, fill in the blank cells in column 1.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Arlen" wrote:

I have data that looks like this on one sheet.

A | B | C

1 Date Trailer Gallons
2 Wed 02/29/07
3 66 1599
4 148 9000
5 Thu 03/01/07
6 66 8008
7 Fri 03/02/07
8 148 21398

On another sheet, using SUMPRODUCT and a static range, I am trying to
separate figures by the months in column A.

How do I add the functionality that says 'When you find Trailer 66 in Column
B, look left and up until you reach a date cell to determine if you're in the
right month?"

Please help if you can.

Arlen