Help with a formula

W

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.
 
F

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.
 

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

Top