A
Athelstone
Let's say I have four rows across, Activity, Budget, Revenue and Priority.
I will have many rows beneath them, with lots of text under activity and
numbers under budget, revenue and priority. I sort on Priority, of which
there are 4- priority 1, priority 2, etc.
Is there a way I can add all the priority 1s together, all the 2s. etc? In
such a way that if I change an activity's priority from 1 to 2 the sums for
all the priorty 1 and 2s change at the same time? Sort of conditional
addition?
Sorry if this is really simple but I am a Word man and this excel stuff
freaks me out - I don't do numbers!
I will have many rows beneath them, with lots of text under activity and
numbers under budget, revenue and priority. I sort on Priority, of which
there are 4- priority 1, priority 2, etc.
Is there a way I can add all the priority 1s together, all the 2s. etc? In
such a way that if I change an activity's priority from 1 to 2 the sums for
all the priorty 1 and 2s change at the same time? Sort of conditional
addition?
Sorry if this is really simple but I am a Word man and this excel stuff
freaks me out - I don't do numbers!