Hi all,

I am not such an expert on Excel so please advise if you can assist with the following.

I have a number of cells, with a rule as follows, but within each cell the company name and month vary, over 836 cells, so I cannot do a find and replace so wanted to know if there was a way of adding the following part to the rest of the formula within the 836 cells in one go, rather than tediously going through each cell and copying/pasting.

The part I would like to add to the various cells - 'Master Quote Sheet'!$H$18:$H$6021, "Won"

Existing formula (the varying parts within the different cells are the "02.2014" and "Company Name"
=SUMIFS('Master Quote Sheet'!$J$18:$J$6021, 'Master Quote Sheet'!$E$18:$E$6021, "Direct", 'Master Quote Sheet'!$A$18:$A$6021, ".02.2014", 'Master Quote Sheet'!$D$18:$D$6021, "Company Name")

If I have to add a Macro, I have no idea what I am doing so please explain as best you can if I have to add any code.

Thanks, Ian