If formula...
 

I need a formula that looks at a column and if that column has a "0" input in
it, then add the number in the cell next to it. I have tried -
IF(H5:H70=0,sum(G5:g70,"")).

If formula...
 

=SUMPRODUCT((H5:H70=0)*(H5:H70<"")*G5:G70), assuming that you don't want to
include those rows where column H is empty.
--
David Biddulph

"heater" wrote in message
...
I need a formula that looks at a column and if that column has a "0" input
in
it, then add the number in the cell next to it. I have tried -
IF(H5:H70=0,sum(G5:g70,"")).

If formula...
 

hi.
Try this....
=IF(SUM(H5:H70)=0,SUM(G5:G70),"")

Regards
FSt1

"heater" wrote:

I need a formula that looks at a column and if that column has a "0" input in
it, then add the number in the cell next to it. I have tried -
IF(H5:H70=0,sum(G5:g70,"")).

If formula...
 

Try this:

=SUMIF(H5:H70,0,G5:G70)

--
Biff
Microsoft Excel MVP


"heater" wrote in message
...
I need a formula that looks at a column and if that column has a "0" input
in
it, then add the number in the cell next to it. I have tried -
IF(H5:H70=0,sum(G5:g70,"")).

If formula...
 

One way:

=SUMIF(H5:H70,0,G5:G70)

In article ,
heater wrote:

I need a formula that looks at a column and if that column has a "0" input in
it, then add the number in the cell next to it. I have tried -
IF(H5:H70=0,sum(G5:g70,"")).