Hello expers,

ArcticAce

New Member
Joined
Feb 23, 2018
Messages
32
I have two issues on an excel spreadsheet that I am trying to get calculations to input into another cell with the sums.

The first issue is I have the following formula in cell I6-I7 (=IF(I6=FALSE, "0", "1") cell number is changed in I7, but I can't figure out a formula to get the sum of the two cells to input into another cell.

The second issue is need to know how to sum several format control combo boxes.

Any help that I can get will be greatly appreciated.
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Both issues are not explained very clearly.
Are you able to provide any attachments which can show your current "stuck state", and then maybe another view showing the result that you would like to achieve?

Also, you should maybe create a separate thread for the second issue as it will be easier to track the support for your question.
 
Upvote 0
Both issues are not explained very clearly.
Are you able to provide any attachments which can show your current "stuck state", and then maybe another view showing the result that you would like to achieve?

Also, you should maybe create a separate thread for the second issue as it will be easier to track the support for your question.
 

Attachments

  • Example.JPG
    Example.JPG
    21.5 KB · Views: 6
Upvote 0

Forum statistics

Threads
1,214,985
Messages
6,122,606
Members
449,089
Latest member
Motoracer88

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top