• REGISTER NOW!! Why? Because you can't do much without having been registered!

    At the moment you have limited access to view all discussions - and most importantly, you haven't joined our community. What are you waiting for? Registration is fast, simple and absolutely free so please, join Join Talking Horses here!

Excel Help

  • Thread starter Thread starter SlimChance
  • Start date Start date
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
 

Recent Blog Posts

Back
Top