Excel -viewer select cells for SUM

Closed
ghinksmon Posts 1 Registration date Tuesday March 23, 2010 Status Member Last seen March 23, 2010 - Mar 23, 2010 at 05:00 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 23, 2010 at 09:45 PM
Help,

What I need appears basic but browsing through other questions I don't see it asked/answered. I'm organizing contractor's bids on projects. Column 'A" is a name, columns b, c, d are his various bids. I know I can use the sum function to combine his bids in another column. However I want the person viewing the table to be able to select which bids are used in the sum instead of all. The viewer should be able to select values by changing the font or shading, not rewriting the formula. Written in english the formula would be: Sum B3:D3 only if BOLD. I can also add hidden columns if necessary.

Thanks

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Mar 23, 2010 at 09:45 PM
For column hiding, there is no formula for sum to exclude such column. VBA would be needed to do that
0