sureshsonti
Member
I have an excel sheet with data tab and qty tab. I am trying to use SUMIFS and COUNTIFS
SUMIFS should calculate QTY from the data tab based on YEAR, MONTH, MATERIAL and PLANT.
COUNTIFS should count the number of times a specific material appears in the data tab based on YEAR, MONTH, PLANT and MATERIAL
Have attached a sample sheet.
Thanks
SUMIFS should calculate QTY from the data tab based on YEAR, MONTH, MATERIAL and PLANT.
COUNTIFS should count the number of times a specific material appears in the data tab based on YEAR, MONTH, PLANT and MATERIAL
Have attached a sample sheet.
Thanks