I want to use SUMIFS with multiple criteria. I want one of my criteria to be a absolute cell reference containing some text. How do i do that?
concatenation or double quotes dont work. Please help me out. Ive attached an image. I want sheet1 B45 in its place which contains text as criteria
concatenation or double quotes dont work. Please help me out. Ive attached an image. I want sheet1 B45 in its place which contains text as criteria