Easy way to exclude cells in Excel Sum formula?
I have a column of numbers. I want to temporarily exclude few cells from being included in the Sum formula. Then add them back.
Right now I have =SUM(K16:K34)
I want to exclude K20 and K22.
Is there an easy way to do this?
Right now I have =SUM(K16:K34)
I want to exclude K20 and K22.
Is there an easy way to do this?
ASKER
I was just hoping something easier to click to exclude and then put it back :)
I guess not..
I guess not..
I would do
=SUM(K16:K34)-K20-K22
=SUM(K16:K34)-K20-K22
ASKER
Thanks guys. I knew I could do it. Was just hoping for something easier like click->exclude. I guess not then.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Very cool idea. Thanks Eirman!
I was still thinking to something simpler like point-n-click but maybe this is just in my head :)
I was still thinking to something simpler like point-n-click but maybe this is just in my head :)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Do it yourself in stages and keep asking questions here.
Post a sample workbook of your progress, and experts are more likely edit it and post it back.
Post a sample workbook of your progress, and experts are more likely edit it and post it back.
For a small range such as you are describing; highlight the first block, press ctrl and then highlight the next block. Only those required will be highlighted and the total will show on the status bar.
Thanks
Rob H
Thanks
Rob H
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
=SUM(K16:K34)-sum(K20,K22)
or
=sum(K16:K19,K21,K23:K34)
Saurabh...