# 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

=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),"")

• Re: Sumif - Referece To Cell On Another Worksheet

Mattenborough, Please don't use code tags around formulas, only around VBA.

• Re: Sumif - Referece To Cell On Another Worksheet

Thanks mattenborough, that toally worked!

## Participate now!

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