Using the lookup Function for similar items to add together
Hello People,
I need to find in column A all the items with a 3 in it and add all items in column B together. Example: A B C H I 1 3 House Results for 3 = 7 3 4 Car 3 2 Bike 2 1 Pool 3 1 Skateboard 4 7 Park What is the best type of lookup and what would the formula look like. Thank you |
Using the lookup Function for similar items to add together
Hi!
Try this: =SUMIF(A1:A6,3,B1:B6) Or, use a cell to hold the criteria: D1 = 3 =SUMIF(A1:A6,D1,B1:B6) Biff "Brian" wrote in message ... Hello People, I need to find in column A all the items with a 3 in it and add all items in column B together. Example: A B C H I 1 3 House Results for 3 = 7 3 4 Car 3 2 Bike 2 1 Pool 3 1 Skateboard 4 7 Park What is the best type of lookup and what would the formula look like. Thank you |
All times are GMT +1. The time now is 10:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com