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
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)

1 reply

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
use the sumifs function.
:)
0