Hi,
In SUMIFS formula instead of giving particular value i want to give cell reference from diffrent sheets. how do i do it..
For Eg: =SUMIFS(A1:A20, B1:B20, ">0", C1:C20, "<10") instead of like this i want to give as below
=SUMIFS(A1:A20, B1:B20, "E30", C1:C20, "G10") where E30 and G10 are the cell references.
Bookmarks