Previous Topic Next Topic

Excel -viewer select cells for SUM

Closed
ghinksmon Posts 1 Registration date Tuesday 23 March 2010 Status Member Last seen 23 March 2010 - 23 Mar 2010 à 17:00
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 23 Mar 2010 à 21:45
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

Related:

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
23 Mar 2010 à 21:45
For column hiding, there is no formula for sum to exclude such column. VBA would be needed to do that