Excel Help

[marine1]

Hey guys need some help.

I have people's names in a column.
Each persons name has a coloured background.
These names are on different dates and times.
On a separate column I have each person's name once and their totals for that month in the next column. Again the background colours are the same as the original columns but obviously only once for each person.
I want to have the totals based on the colours in the right.
I have a formula that someone once sent me but for some reason when I select the formula and try copy and paste it does not allow me.

Please can someone assist?
Thanks
=SumByCFColorIndex2($C$2:$D$42,ColorIndexOfCF(F5,FALSE))

Now how would I copy and paste onto the next line or is there an easier way of doing this?

 

[Venomous]

which version of Excel do you use?

it's possible the original person locked all cells you don't normally need to put data into.

 

[KalMaverick]

It's difficult to help without seeing exactly what you want to do.

But wouldn't it be easier using one of the lookup functions or a sumif.

EDIT: As for not being able to copy the formula, check if the document is protected.

 

[gus]

Is it not maybe entered as an array formula? Check for { braces around the formula, also use Shift-Ctrl+Enter to copy the array formula.

Also, it might be obvious, but this is a user defined function, you sure you have the module included in the new sheet? Just guessing, but without more info, thats all I can hazard!

Good luck

 

[marine1]

Eish, using Excell 2007 and now see there is a macro, holy crap, how is one supposed to understand it without knowing Basic?
Thanks guys will try make heads or tails and post further

 

[marine1]

But wouldn't it be easier using one of the lookup functions or a sumif.

What is that?

 

[agentrfr]

Um, marine, I don't meant to be nasty, but I've seen you post a bunch of excel threads. You should be able to ask the office techie where you can go for an ICDL - it should save you a lot of headaches in the future

 

[marine1]

Um, marine, I don't meant to be nasty, but I've seen you post a bunch of excel threads. You should be able to ask the office techie where you can go for an ICDL - it should save you a lot of headaches in the future

Lol, no offense taken, I am the office techie, just kidding, we dont have one and I dont normally use it, its just for me to simplify some stuff. Turning out to be more complicated than I thought.

 

[Rock Bottom Computers]

Marine, maybe you have done this, but I usually copy----(select cells)---paste special---formulas.

Sometimes that dont work for the following two reasons.
The exel worksheet your working in should be copied to the new version of excel.
The blank cell in the column line should be selected and then press "del" on those blank cell.
Hope it helps.

 

[kerbyross]

Marine 1 , send me a PM with your email address.
I have an excel spreadsheet that I use for backups.
It counts successful backups = green , failed backups = red , should help you out.