Drewmyster
Board Regular
- Joined
- May 16, 2007
- Messages
- 150
- Office Version
- 365
- Platform
- Windows
I know I’ve done this before but I cannot for the life of me remember how to do it.
Example of what I’m trying to do;
A1 = “Apples” then lookup Sheet1, within column A, find matches, then calculate the sum of values in column B.
So if Sheet1 has three rows that contain “Apples” in column A, and each of them has a value of “3” in column B, then add the total numerical value of column B to equal ”9”
How is this done?
Example of what I’m trying to do;
A1 = “Apples” then lookup Sheet1, within column A, find matches, then calculate the sum of values in column B.
So if Sheet1 has three rows that contain “Apples” in column A, and each of them has a value of “3” in column B, then add the total numerical value of column B to equal ”9”
How is this done?