I need help with a text and quantity summary report.
I am trying to find a formula that will search another worsheet for a
specific text (product) and also sum up the quantitys used. The items may appear on the same spreadsheet more tnan once so I will need to use a range of A1:A500 to search for the product number, then total the quantities in the adjoining cell, even if it appears more than once on the same spreadsheet. e.g. House no. DEVELOPMENT ESP1234N 15 29 READING NHB5669 9 5 MILTON KEYNES I have 5 workbooks for each day of the week and Im aiming to summarise the quantity's used for each item in a 'stock movement' summary. I only need the first two colum results for the stock movement summary report. Please help, this is driving me nuts :( |
I need help with a text and quantity summary report.
Looks like you need SUMIF
=SUMIF(A1:A500,"productname",B1:B500) |
I need help with a text and quantity summary report.
Thats done it :) Excellent thank you very much.
"daddylonglegs" wrote: Looks like you need SUMIF =SUMIF(A1:A500,"productname",B1:B500) |
All times are GMT +1. The time now is 05:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com