# Re: SUMIF and cell references.

• From: Jody Goldberg <jgoldberg home com>
• To: Gordon Oliver <gordo pincoya com>
• Cc: gnumeric-list gnome org
• Subject: Re: SUMIF and cell references.
• Date: Fri, 14 Sep 2001 20:24:53 -0400

```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)

```