SUM total data

[MadHatsJess]

Hi Hope someone can help me please

I have a spreadsheet full of data that is not totalled. I cant think of a way to do it.

In total I need about 1500 totals so it will take a long time to do manually.

See example below

Each mini table of data has multiple lines (rows between them)

Code	Name	Value
00	Apple	10
00	Apple	15
04	Pear	10
04	Pear	5
04	Pear	20

<tbody>
</tbody>

Thanks

Jess

 

[alansidman]

Suggest you look at employing the Sub Total Function available in Excel.

https://www.contextures.com/excelfunctionsubtotal.html

 

[jtakw]

Hi,

SUMIF or SUMIFS might also be of interest.