Hi Tevia,

Enter a help column in column A. Next to each total row, in column A, type
'TOTAL' into the cell. Assuming your data is in rows 1 to 99, in column
B100, enter the formula: = SUMIF($A$1:$A$99,"total",B1:B99) and drag this
across as many columns as needed.

Reply if you need any more help.

Ewan.

"tevia" wrote:

Hi Ewan,
Each bold cell is the autosum of the few cells above it. The number of cells
being added up differs each time, so, for example, I have autosums of cells
h2 to h18 followed by an autosum of cells h20 to h115, then h116 to h196 and
so on.
--
tevia


"ewan7279" wrote:

Hi Tevia,

What determines whether the cell contents are bold or otherwise?

"tevia" wrote:


'i want to add up all the bold cells in a column using the 'sumif' formula.
How do I do this? I don't know how to signify 'bold' in the formula bar
I'm using Excel 2002
--
tevia