Merged Cells

[Kurt Hili]

Hi all,

New to this and not sure whether this question has been answered before. Sorry if it has.

In the attached sheet, what I need to do is have a sum of Column 'A' in Column 'B'. This should sum up all adjacent and matching values in column 'A'. So for example, by means of a formula, B2:B9 = 3,222. B10:17 = 3,349 and B18:B30 = 7,224 and so on.

Second step is for column 'C' to add matching values in Columns 'D', 'E, and 'F'. Therefore, C3:C9 = 1,200, C10:C17 = 12,000 and C18:C30 = 3,000 and so on.

Is this even possible?

Thanks in advance.
Kurt

 

[Asheesh]

Hi,

Welcome to the forum..

Quick Question: Are there any more columns or fields associated to the data..If so can you share the sample please.

 

[Kurt Hili]

Thank you for your reply...

To answer your question; Yes, there could be descriptive fields as per attached.

Thanks
Kurt

 

[bosco_yip]

Try.............



1] In Column D "Sum of Name" D2, enter formula :

=SUMPRODUCT((LOOKUP(ROW(B$2:B$59),ROW(B$2:B$59)/(B$2:B$59<>""),B$2:B$59)=T(IF(1,INDIRECT("R"&ROW()&"C2",0))))*C$2:C$59)

Then,

Select D2 >> In the Formula Bar, use mouse pointer highlighted the formula >> Mouse right click, choose "Copy" >> Goto below merged cells, and "Paste" one by one.

2] In Column E "Sum of Col F:H" E2, enter formula :

=SUM(INDIRECT("R"&ROW()&"C6:C8",0))

Then do the Copy and Paste to the below cells as per above [1]

3] See attached file

Regards
Bosco

 

[Kurt Hili]

Thanks, Bosco.

Life saver. Have a good one.

Kurt