Hi....
The way you described the function below, still doesn't work ....
I mean.... When I want to use the cell reference i.e. Cell 12: 5/20/2002
And I want to use the sumif as follows: (need to use 'greater than' in criteria)
sumif (E3:E9, "=" > C12, F3:F9 )
Whereas E3: 5/10/2002 F3: 100
E4: 5/12/2002 F4: 100
E5: 5/14/2002 F5: 200
E6: 5/19/2002 F6: 100
E7: 5/22/2002 F7: 300
E8: 5/24/2002 F8: 200
E9: 5/27/2002 F9: 100
The answer should be: 600
I'm getting the answer: 0 !
Help!
Message: 6623537
FROM: Jody Goldberg
DATE: 09/14/2001 17:24:53
SUBJECT: RE: SUMIF and cell references.
On Mon, Mar 26, 2001 at 05:36:53PM -0800, Gordon Oliver wrote:
> Hi.
> I'd like to use SUMIF to write a simple formula that would use a reference in
> the criteria, and cannot figure out how to do so (the documentation only has
> simple cases...)
>
> The basic idea is:
> SUMIF(A1:A35,"=A40",C1:C35)
>
> where A1-A35 have names, and then C40 would have the sums for column
> C that match the name in A40... Obviously the above code does not work... it
> compares to the string constant "A40" (as far as I can tell).
>
> The reason is that I'd really rather not hard code those names into the cell
> function, as you don't see that unless you look.. (I hate duplicating constants,
> esp. in places I don't see them)...
>
> Is there any way to do this?
This just popped up in my mailbox. I have no idea why it took so
long. Gotta love @home.
Yes there is definitely a way to do this.
> SUMIF(A1:A35,"=A40",C1:C35)
SUMIF(A1:A35,"="&A40,C1:C35)
Susan J. Zupnik
System Designer
Tunnels, Bridges & Terminals Department
One Path Plaza - 8th Floor
Jersey City, NJ 07306
Email: szupnik panynj gov
AIM Screen Name: ZupWork