Total is sum of bold values

  • Thread starter Thread starter Saj
  • Start date Start date
S

Saj

Suppose I have a the following columns in a Excel
Worksheet :-

A B C D
4 (b) 6 4 (b) 5
6 6 (b) 6 (b) 6
3 (b) 6 (b) 4 4
6 4 (b) 3 1 (b)
--------------------------------------------------
SUM
--------------------------------------------------
7 16 10 1

The totals add only the values that are bold..
(b denotes bold text)

How can I make this (Total/Bold) functionality to work in
Excel ?
 
Back
Top