Hi Team,
I have a requirement where I want to product two columns based on a Name criteria and the criteria is "NA".It will multiply only when NA is found in Name.
e.g:Apr-18 col of Overall capcity will be multiplied by Apr-18 column of D&P.Finally I want the total sum and that will be revenue monthwise.Sample sheet attached.
Regards,
Aps
Bookmarks