copying SUMIF statements

[bradyk819]

I'm trying to find out how to copy a SUMIF statement that I've made to
add up values for specific accounts.

I've developed the SUMIF formula for brand X, and now I want to be
able to copy the formula for a different brand Y, without having to
manually go into the formula and change every "X" reference to a "Y"
reference. Any suggestions?...

 

[Don Guillett]

Have a look in the help index for INDIRECT

 

[Peo Sjoblom]

Put the criteria (brand) in a cell and use that cell reference

=SUMIF(Range1,A2,Range2)


That way you only need to change the contents in the cell

Use Ctrl + h to find and replace


--


Regards,


Peo Sjoblom

 

[Don Guillett]

or just this idea where b1 contains y or x
=sumif(a2:a22=b1,b2:b22)

 

[RagDyeR]

Create a list of your brands in a column, say,
Z1 to Z(whatever),

Then reference the cells in the list, so as you drag down to copy, the
"brand" changes on each row.

-Sumif(A$2:A$100,Z1,B$2:B$100)
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I'm trying to find out how to copy a SUMIF statement that I've made to
add up values for specific accounts.

I've developed the SUMIF formula for brand X, and now I want to be
able to copy the formula for a different brand Y, without having to
manually go into the formula and change every "X" reference to a "Y"
reference. Any suggestions?...