Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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,"")). |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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,"")). |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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,"")). |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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,"")). |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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,"")). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|