flowing of numbers

[great_AS]

Hi guys!!

Do you know how to let the numbers of the tables in the red array (sample.xlsx), to flow into the blue one?

Thanks in advance!
AS

[Glenn Kennedy]

It would help if you were to tell us what your expected results are !!!

[Pete_UK]

Do you mean that you want to add the corresponding values together in the blue area? If so, put this formula in E34:

=SUMIF($D$8:$D$28,$D34,E$8:E$28)

then copy across.

Hope this helps.

Pete

[great_AS]

Yeah perfect! Basically I wanted a function that combined the tables within the red frame to the blue one!

Many thanks Pete!!!