Help with a formula

[winnie123]

Hi I hope someone can help me out

I have created a spreadsheet which I want to summarise data from another file.

The source file is a forecast of parts as is laid out as follows

col E row 2 contains the part numer
col G to AP row 3 contains dates ie,02-Feb,09-Feb,02-Mar,06-Apr
col G to AP row 4 cointains the qty of units required

In the summary file I have

col A cointains the part number

I want to enter a formula that will look up the part number in col A and sum
the qty of units required for Feb,March and so on.

I have tried using lookup with sumproduct but I keep getting zero.

Any suggestions would be appreciated, hope you have enough info to go on.

 

[Fred Smith]

First, Winnie, don't hijack other people's threads. This a new conversation,
so start a new thread. You eliminate a lot of the people who might be able
to help out, because a lot don't look at old threads.

Second, show the formula you have tried! I can't believe the number of
people who don't do this. How can we help you when we don't know what has
gone wrong?

Third, when you say you have "dates", we assume you have a valid Excel date,
not text. The difference is crucial. The easiest way to find out is to
reformat the cell. If it reformats as requested, then you have a date. If
not, it's text. Let us know in your response.

Regards,
Fred.

 

[Roger Govier]

see response to your later posting