How to copy a conditional sum, but change the column
The {=formula} means the formula is an Array formula.
When editing use CTRL + SHIFT + ENTER instead of just ENTER
Gord Dibben MS Excel MVP
On Tue, 5 Aug 2008 10:13:01 -0700, maharana.santnu
wrote:
"Stabilos" wrote:
I have used the conditional sum wizard to create a sum of a column for
period 1 based on certain criteria. I can copy this conditional sum to the
next column for period 2 using the same criteria, but of course it is working
out the sum based on period 1 column data. I tried to go into the fourmula
bar and change the column cell reference. This action deletes the {} at
front and back of the formula. When I type them in again. The function of
hte conditional sum formula is lost.
Is there a way to achieve what I am trying to do without having to use the
conditional sum wizard on every column?
|