jacquelinemym
New Member
- Joined
- Feb 14, 2014
- Messages
- 2
Hello,
I appreciate any help I can receive on this.
1-I have a drop down list of text. How do I add a numerical value of '1' in order to then sum drop down selections? (if this is a necessary first step)
Currently the list starts in A1 and continues down in the A column on a separate page from the drop down cells
2-on a summary page, I am trying to total all the selections (in column CA starting at CA4 continuing down) from pages 1-5 where the drop down is used, all in CA starting at CA4.
Portion of the list-
<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>
I appreciate any help I can receive on this.
1-I have a drop down list of text. How do I add a numerical value of '1' in order to then sum drop down selections? (if this is a necessary first step)
Currently the list starts in A1 and continues down in the A column on a separate page from the drop down cells
2-on a summary page, I am trying to total all the selections (in column CA starting at CA4 continuing down) from pages 1-5 where the drop down is used, all in CA starting at CA4.
Portion of the list-
Beauty |
Child Services |
Consulting |
Counseling/Coach |
Finance |
Fitness |
Home Improvement/ Maintenance |
Mortgage Broker |
Realtor |
Retail |
Social Events/Networking |
Wellness THANK YOU in advance. |
<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>