SUM rows in column if cell in different column is empty

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nospam@iamtheonewho.com - 13 Mar 2007 00:43 GMT

Hi,

I have a spreadsheet that has many rows of data. I'm trying to get a
total for a column ("G") in a cell ("A2") but only on rows where the
cell in another column ("J") for that row is empty.I tried SUMIF and
couldn't get it to work. Can this be done with some kind of formula?
Any help would be appreciated.

Thanks,

gg

Reply to this Message

Bob Phillips - 13 Mar 2007 00:51 GMT

=SUMIF(I:I,"",G:G)

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Hi,
>
[quoted text clipped - 7 lines]
>
> gg

Reply to this Message

Dave Peterson - 13 Mar 2007 00:54 GMT

Maybe...

=SUMIF(J:J,"",G:G)

> Hi,
>
[quoted text clipped - 7 lines]
>
> gg

Signature

Dave Peterson

Reply to this Message

nospam@iamtheonewho.com - 13 Mar 2007 01:10 GMT

Thanks... I'm an idiot. I have like 7 rows of non-numberical data
that I was trying to "exclude" when I tried the SUMIF. I thought that
would mess it up. Thanks for the help. I probably would have never
figured it out. =)

Reply to this Message