S
SlimChance
Guest
Can anyone help me use the below formula with two rules?
=SUMIF('Sheet2'!A:A,'Sheet1'!B87,'Sheet2'!G:G)
I only want it to sum G:G where it also equals B:B on sheet2 = A86 on sheet1
=SUMIF('Sheet2'!A:A,'Sheet1'!B87,'Sheet2'!G:G)
I only want it to sum G:G where it also equals B:B on sheet2 = A86 on sheet1