software

I am trying to find a short cut for the if funtion. Here is my formula (it
takes so long to input and then when I want to copy it to a new set of
values, it takes a long time to revise. Here is my recent formula for on one
of the values that I need.
=IF(C5=1,SUM(D5),0) IF(C6=1,SUM(D6),0) IF(C7=1,SUM (D7),0) IF(C21=1,SUM(D21),0) IF(C22=1,SUM(D22),0) IF(C23=1,SUM(D23),0) IF(C24=1,SUM(D24),0) IF(C25=1 ,SUM(D25),0) IF(C35=1,SUM(D35),0) IF(C36=1,SUM(D36 ),0) IF(C37=1,SUM(D37),0) IF(C38=1,SUM(D38),0) IF( C39=1,SUM(D39),0) IF(C40=1,SUM(D40),0) IF(C41=1,SU M(D41),0) IF(C42=1,SUM(D42),0) IF(C43=1,SUM(D43),0 ) IF(C44=1,SUM(D44),0) IF(C45=1,SUM(D45),0) IF(C46 =1,SUM(D46),0) IF(C47=1,SUM(D47),0)
This is what I tried to do, =IF(C5:C47=1,SUM(D547),0) but it does not like
the (C5:C47)
--
Sheri

First, your SUM()s are superfluous: SUM(D5) is equivalent to D5.

Try:

=SUMIF(C5:C47,1,D547)In article gt;,
quot;Sheriquot; gt; wrote:

gt; I am trying to find a short cut for the if funtion. Here is my formula (it
gt; takes so long to input and then when I want to copy it to a new set of
gt; values, it takes a long time to revise. Here is my recent formula for on one
gt; of the values that I need.
gt; =IF(C5=1,SUM(D5),0) IF(C6=1,SUM(D6),0) IF(C7=1,SUM (D7),0) IF(C21=1,SUM(D21),0)
gt; IF(C22=1,SUM(D22),0) IF(C23=1,SUM(D23),0) IF(C24= 1,SUM(D24),0) IF(C25=1,SUM(D
gt; 25),0) IF(C35=1,SUM(D35),0) IF(C36=1,SUM(D36),0) I F(C37=1,SUM(D37),0) IF(C38=1
gt; ,SUM(D38),0) IF(C39=1,SUM(D39),0) IF(C40=1,SUM(D40 ),0) IF(C41=1,SUM(D41),0) IF
gt; (C42=1,SUM(D42),0) IF(C43=1,SUM(D43),0) IF(C44=1,S UM(D44),0) IF(C45=1,SUM(D45)
gt; ,0) IF(C46=1,SUM(D46),0) IF(C47=1,SUM(D47),0)
gt; This is what I tried to do, =IF(C5:C47=1,SUM(D547),0) but it does not like
gt; the (C5:C47)

quot;Sheriquot; gt; wrote in message
...
gt;I am trying to find a short cut for the if funtion. Here is my formula (it
gt; takes so long to input and then when I want to copy it to a new set of
gt; values, it takes a long time to revise. Here is my recent formula for on
gt; one
gt; of the values that I need.
gt; =IF(C5=1,SUM(D5),0) IF(C6=1,SUM(D6),0) IF(C7=1,SUM (D7),0) IF(C21=1,SUM(D21),0) IF(C22=1,SUM(D22),0) IF(C23=1,SUM(D23),0) IF(C24=1,SUM(D24),0) IF(C25=1 ,SUM(D25),0) IF(C35=1,SUM(D35),0) IF(C36=1,SUM(D36 ),0) IF(C37=1,SUM(D37),0) IF(C38=1,SUM(D38),0) IF( C39=1,SUM(D39),0) IF(C40=1,SUM(D40),0) IF(C41=1,SU M(D41),0) IF(C42=1,SUM(D42),0) IF(C43=1,SUM(D43),0 ) IF(C44=1,SUM(D44),0) IF(C45=1,SUM(D45),0) IF(C46 =1,SUM(D46),0) IF(C47=1,SUM(D47),0)
gt; This is what I tried to do, =IF(C5:C47=1,SUM(D547),0) but it does not
gt; like
gt; the (C5:C47)
gt; --
gt; Sheri

=SUMPRODUCT((C5:C47=1)*(D557))

Ciao
Bruno
Sheri,

=SUMPRODUCT(C5:C47,D547)

may work, depending on what you have besides 1s in cells C5:C47 - 0 or blank is okay, other numbers
are bad for this.

=SUM(IF(C5:C47=1,D547))
Entered using Ctrl-Shift-Enter will definitely work.

HTH,
Bernie
MS Excel MVPquot;Sheriquot; gt; wrote in message
...
gt;I am trying to find a short cut for the if funtion. Here is my formula (it
gt; takes so long to input and then when I want to copy it to a new set of
gt; values, it takes a long time to revise. Here is my recent formula for on one
gt; of the values that I need.
gt; =IF(C5=1,SUM(D5),0) IF(C6=1,SUM(D6),0) IF(C7=1,SUM (D7),0) IF(C21=1,SUM(D21),0) IF(C22=1,SUM(D22),0) IF(C23=1,SUM(D23),0) IF(C24=1,SUM(D24),0) IF(C25=1 ,SUM(D25),0) IF(C35=1,SUM(D35),0) IF(C36=1,SUM(D36 ),0) IF(C37=1,SUM(D37),0) IF(C38=1,SUM(D38),0) IF( C39=1,SUM(D39),0) IF(C40=1,SUM(D40),0) IF(C41=1,SU M(D41),0) IF(C42=1,SUM(D42),0) IF(C43=1,SUM(D43),0 ) IF(C44=1,SUM(D44),0) IF(C45=1,SUM(D45),0) IF(C46 =1,SUM(D46),0) IF(C47=1,SUM(D47),0)
gt; This is what I tried to do, =IF(C5:C47=1,SUM(D547),0) but it does not like
gt; the (C5:C47)
gt; --
gt; Sheri
Looks like you need the the SUMIF() function:

=sumif(C5:C47,1,D547)quot;Sheriquot; wrote:

gt; I am trying to find a short cut for the if funtion. Here is my formula (it
gt; takes so long to input and then when I want to copy it to a new set of
gt; values, it takes a long time to revise. Here is my recent formula for on one
gt; of the values that I need.
gt; =IF(C5=1,SUM(D5),0) IF(C6=1,SUM(D6),0) IF(C7=1,SUM (D7),0) IF(C21=1,SUM(D21),0) IF(C22=1,SUM(D22),0) IF(C23=1,SUM(D23),0) IF(C24=1,SUM(D24),0) IF(C25=1 ,SUM(D25),0) IF(C35=1,SUM(D35),0) IF(C36=1,SUM(D36 ),0) IF(C37=1,SUM(D37),0) IF(C38=1,SUM(D38),0) IF( C39=1,SUM(D39),0) IF(C40=1,SUM(D40),0) IF(C41=1,SU M(D41),0) IF(C42=1,SUM(D42),0) IF(C43=1,SUM(D43),0 ) IF(C44=1,SUM(D44),0) IF(C45=1,SUM(D45),0) IF(C46 =1,SUM(D46),0) IF(C47=1,SUM(D47),0)
gt; This is what I tried to do, =IF(C5:C47=1,SUM(D547),0) but it does not like
gt; the (C5:C47)
gt; --
gt; Sheri

Maybe..........

=SUMIF(C5:C7,1,D57) SUMIF(C21:C25,1,D2125) SUM IF(C35:C47,1,D3547)

Vaya con Dios,
Chuck, CABGx3
quot;Sheriquot; wrote:

gt; I am trying to find a short cut for the if funtion. Here is my formula (it
gt; takes so long to input and then when I want to copy it to a new set of
gt; values, it takes a long time to revise. Here is my recent formula for on one
gt; of the values that I need.
gt; =IF(C5=1,SUM(D5),0) IF(C6=1,SUM(D6),0) IF(C7=1,SUM (D7),0) IF(C21=1,SUM(D21),0) IF(C22=1,SUM(D22),0) IF(C23=1,SUM(D23),0) IF(C24=1,SUM(D24),0) IF(C25=1 ,SUM(D25),0) IF(C35=1,SUM(D35),0) IF(C36=1,SUM(D36 ),0) IF(C37=1,SUM(D37),0) IF(C38=1,SUM(D38),0) IF( C39=1,SUM(D39),0) IF(C40=1,SUM(D40),0) IF(C41=1,SU M(D41),0) IF(C42=1,SUM(D42),0) IF(C43=1,SUM(D43),0 ) IF(C44=1,SUM(D44),0) IF(C45=1,SUM(D45),0) IF(C46 =1,SUM(D46),0) IF(C47=1,SUM(D47),0)
gt; This is what I tried to do, =IF(C5:C47=1,SUM(D547),0) but it does not like
gt; the (C5:C47)
gt; --
gt; Sheri