Anbuselvam K
Member
Hi
As per the below image, I have used the SUMPRODUCT formula in the cells L3 to L13.
In the Second row some of the RM not having the prices in the first row (D, E, I, and J)
But, The formula sumproduct has given the results as usual.
I need to get the indications if the Products having Values in the RM and that RM doesn't have a price in row1.
Eg: Products 2 and 3 used RM E and F which doesn't have a price in row1.
So Products 2 and 3 need to indicate in the price/kg column L (By colour change or some other indication)
Thanks in advance.
As per the below image, I have used the SUMPRODUCT formula in the cells L3 to L13.
In the Second row some of the RM not having the prices in the first row (D, E, I, and J)
But, The formula sumproduct has given the results as usual.
I need to get the indications if the Products having Values in the RM and that RM doesn't have a price in row1.
Eg: Products 2 and 3 used RM E and F which doesn't have a price in row1.
So Products 2 and 3 need to indicate in the price/kg column L (By colour change or some other indication)
Thanks in advance.