I need a basic function

[Elizabeth.gall]

I need a formula that will sum a number of values in different cells and different columns but only if lets say a box is checked next to the value.
HELP!!!

[EdMac]

Looks rather like the other thread

http://www.excelforum.com/excel-gene...ng-values.html

locked by shg as the title was not according to the rules.....

Please use the correct format for your titles - if you read the rules and also see what others do, there shouldn't be a problem.

[shg]

Thread closed.

Elizabeth, I strongly urge that you read the forum rules.