Sumif - Reference To Cell On Another Worksheet

  • I'm trying to reference a cell on another worksheet in my criteria and the formula doesn't seem to be working. All I get is a value of 0.


    =SUMIF(G3:G76, ">='City Wide'!B6",I3:I76)


    If I replace 'City Wide'!B6 with an actual number the formula works. This does not help as 'City Wide'!B6 is a value that can change.

  • Re: Sumif - Referece To Cell On Another Worksheet


    How about this?


    =SUMIF(A11:A16,">="&'City Wide'!B3,Sheet1!B11:B16)


    A11:A16 is the area I am testing
    City Wide sheet cell B3 is what I am comparing to
    B11:B16 is what I am summing when there is a match



    Cheers!
    Michael

  • Re: Sumif - Referece To Cell On Another Worksheet


    Garchu,


    I am not fully understanding what you are trying to do. Are you checking the sum of B3:B75, or looking at each cell in the range. If you are looking at the sum, than you can use:


    =If(Sum(G3:G75)>=City Wide!B6,Sum(I3:I75),"")

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!