formula to look at a part numbe and a qty

August 23, 2011 at 04:29:58
Specs: Windows XP
Firstly thanks to the peeps who have helped me previously, albeit I'm not that good at explaining exactly what it is I am trying to do\achieve. anyway another puzzle.

I have a continious running spreadsheet of all stationary orders placed and I need to keep a check on the most common items to watch just how many we are going through, so this is what I have

In column 'C' I have the qty, 'F' has the unique code ref,

What I want in columns I through R is the total so as I2 through R2 has the running total
for instance I want any cell in column I (running down) to look at 'F' and if it contains the code (2.547.525) to then look at 'C' and return the total. if the code is not in 'F' leave blank, and again for 'J' to look at 'F' and if it contains (701.079) and so on I know this would result in and error where the code is not found but that can be hidden with a simply ISERROR conditional format. I then want L2 to R2 to look down the colums and have the running total.

I then have another worksheet that adds the totals for each tab (depot)

Again I appologise if this is not explained very clear but it's easy to know what I want but not easy to put it into text.

See More: formula to look at a part numbe and a qty

Report •

August 23, 2011 at 14:04:24
Looking up each code can be done with an IF statement or VLOOKUP. "Errors" can probably be dealt with within the formula itself and not need any conditional formatting.

All that said, it's not clear to me what you mean by "I then want L2 to R2 to look down the colums and have the running total."

Please click on the following line and read the instructions on how to post data in this forum. Then post a sample of your data which might help clear things up.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

August 24, 2011 at 00:02:57
Req	Date	Qty		Description	Item No	Unit Cost	Total	Example 1	Example 2	Example 3	Example 4	Example 5
x							£282	30	12	0	0	6
213726	12/08/2011	6	Tin	Example 1	701.079	£14.30	£85.80	6				
213726	12/08/2011	6	No	Example 2	2.547.525	£1.15	£6.90		6			
213525	01/08/2011	6	Tin	Example 2	2.547.525	£1.15	£27.60		6			
213525	01/08/2011	24	No	Example 1	701.079	£14.30	£85.80	24				
213294	13/07/2011	6	Box	Example 5	1.538.675	£12.70	£76.20					6

Report •

September 14, 2011 at 23:35:31
Hi anyone managed to resolve my problem please

Report •

Related Solutions

Ask Question