Looking up and adding the values fixing different criteria
Closed
Mizan
-
Aug 2, 2015 at 07:06 AM
M.Hanzla Posts 14 Registration date Thursday July 16, 2015 Status Member Last seen August 14, 2015 - Aug 3, 2015 at 08:20 AM
M.Hanzla Posts 14 Registration date Thursday July 16, 2015 Status Member Last seen August 14, 2015 - Aug 3, 2015 at 08:20 AM
Hello,
"A column" the name of items such as Tiles, Pipes, Tables etc (many times repeated)
"B Column" the size of each item such as 10mm, 20mm, 50mm etc (i.e. tiles may be 10mm, 20 mm, 50mm, and the sizes can be repeat)
"C column" is the quantity of each item of each size.
The file has many cells/values.
Now I want to add in different column of each of the item of each size(i.e. tiles of 10mm how many quantity, tiles of 20mm how many quantity etc)
"A column" the name of items such as Tiles, Pipes, Tables etc (many times repeated)
"B Column" the size of each item such as 10mm, 20mm, 50mm etc (i.e. tiles may be 10mm, 20 mm, 50mm, and the sizes can be repeat)
"C column" is the quantity of each item of each size.
The file has many cells/values.
Now I want to add in different column of each of the item of each size(i.e. tiles of 10mm how many quantity, tiles of 20mm how many quantity etc)
Related:
- Based on the values in cells b77 b88
- Based on the values in cells b77 ✓ - Excel Forum
- Instagram account based in wrong country - Instagram Forum
- Based on the values in cells b77 b81 ✓ - Excel Forum
- Excel macro to create new sheet based on value in cells - Guide
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history. - Facebook Forum
1 response
M.Hanzla
Posts
14
Registration date
Thursday July 16, 2015
Status
Member
Last seen
August 14, 2015
1
Aug 3, 2015 at 08:20 AM
Aug 3, 2015 at 08:20 AM
use the sumifs function.
:)
:)