LOOKUP FUNCTION WITH SUMS ABILITY
Hello,
There might be a simple answer here but either way I need help, let me explain my problem. For example "SHEET1" has granny smith apples in A1, "SHEET2" has granny smith apples located in A:A (more than one entry) and price per granny smith apple in B:B. So an example might be granny smith - 10p or on another row the granny smith apple might be 15p, now what I need from sheet1 is the total value of granny smith apples. So I guess I require a lookup function that sums values, is this process possible? Any help or advice would be greatly appreciated. Regards, James. |
SUMIF() did it for me. With "Granny Smith" in Sheet1!A1, a series of
different apple names in Sheet2!A1:A10, and apple prices in Sheet2!B1:B10 the formula on Sheet1!B1 is =SUMIF(Sheet2!A1:A10,A1,Sheet2!B1:B10) |
All times are GMT +1. The time now is 09:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com