SUM rows in column if cell in different column is empty

[Guest]

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

 

[Bob Phillips]

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

--
---
HTH

Bob

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

 

[Dave Peterson]

Maybe...

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

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

 

[Guest]

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. =)