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 B:B on sheet2 = A86 on sheet1
 
unless of course you are saying you want it to sum where A:A matches B87 AND B:B matches A86, in which case you'll need Excel 2007 or newer and it'll be

=SUMIFS('Sheet2'!G:G,'Sheet2'!A:A,'Sheet1'!B87,'Sheet2'!B:B,'Sheet1'!A86)
 
simmo said:
unless of course you are saying you want it to sum where A:A matches B87 AND B:B matches A86, in which case you'll need Excel 2007 or newer and it'll be

=SUMIFS('Sheet2'!G:G,'Sheet2'!A:A,'Sheet1'!B87,'Sheet2'!B:B,'Sheet1'!A86)
Click to expand...


I was going to say that :whistle:
 
simmo said:
unless of course you are saying you want it to sum where A:A matches B87 AND B:B matches A86, in which case you'll need Excel 2007 or newer and it'll be

=SUMIFS('Sheet2'!G:G,'Sheet2'!A:A,'Sheet1'!B87,'Sheet2'!B:B,'Sheet1'!A86)
Click to expand...

Now I also want to count the number of entries. What do i need to change this to? I need it to also factor in cell A103 from AB:AB on the profit and loss sheet.

=COUNTIF('bets record'!C:C,'profit and loss'!B103)
 
If you're counting the original formula, then it would be =COUNTIFS('Sheet2'!A:A,'Sheet1'!B87,'Sheet2'!B:B,'Sheet1'!A86)

obviously you can use adjust them accordingly to match the criteria you have in mind just add/replace any others as (criteria range, criteria).
 
Back
Top