Excel Question

[outlander]

Hi guys, please advise whether this function exists in Excel:

I'm trying to automate the summation of alternate cells. Say cell A1 has a formula "=A50+A55+A58", cell B1 has a formula "=C50+C55+C58", cell C1 is "=E50+E55+E58". I can't possibly click and drag the formula across to D1, E1, F1 and so on since that would not sum the alternate cells I want. Is there anyway I can just drag the formula instead of keying them manually?

[Pokémon]

What kind of tabulation are you trying to achieve with that kind of formula setting?

It seems not a common practice that people would create formula in such a way.

[outlander]

I have a table with the headings Price, Amount, Value. This table is updated monthly. In a separate report, I need to present the monthly Value from the table.

[outlander]

No help from anyone?

[SarahCheng]

pls check ur pm

[Pokémon]

pls check ur pm

Asking for a fee to provide answer is it? If not why so secretive...?

[lobo76]

you know how to use pivot table?

[SarahCheng]

my pm was asking on whether he can use access instead of excel lah..

Thanks

[pclum]

can u use macro ? u can use the relative function in macro ? may be u can state ur question more clearly.