copying SUMIF statements

  • Thread starter Thread starter bradyk819
  • Start date Start date
B

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?...
 
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
 
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?...
 
Back
Top