Combining Totals on Successive Rows Based on Two Criterion

[razorsharpe]

I want to combine the totals of this row and the next "x" rows,
depending on whether Row B (our invoicing 1-1400(which has merged
cells)) matches with Row K (data designation(ie. data1, data2, data3
are the options for Row K), then total from Row O (funds per line).

To do this I have tried the following option, but have run into the
excel too many parameters for calculation constant.

=IF(B20<>B13+1,SUMIF(K13:K20,"Rig
11",O13:O20),IF(B19<>B13+1,SUMIF(K13:K19,"Rig
11",O13:O19),IF(B18<>B13+1,SUMIF(K13:K18,"Rig
11",O13:O18),IF(B17<>B13+1,SUMIF(K13:K17,"Rig
11",O13:O17),IF(B16<>B13+1,SUMIF(K13:K16,"Rig
11",O13:O16),IF(B15<>B13+1,SUMIF(K13:K15,"Rig
11",O13:O15),IF(B14<>B13+1,SUMIF(K13:K14,"Rig
11",O13:O14),SUMIF(K13,"Rig 11",O13))))))))

Please help, if you comprehend my question.

thanks,
razorsharpe

 

[Franz Verga]

I want to combine the totals of this row and the next "x" rows,
depending on whether Row B (our invoicing 1-1400(which has merged
cells)) matches with Row K (data designation(ie. data1, data2, data3
are the options for Row K), then total from Row O (funds per line).

I think you mean coloumns...

To do this I have tried the following option, but have run into the
excel too many parameters for calculation constant.

=IF(B20<>B13+1,SUMIF(K13:K20,"Rig
11",O13:O20),IF(B19<>B13+1,SUMIF(K13:K19,"Rig
11",O13:O19),IF(B18<>B13+1,SUMIF(K13:K18,"Rig
11",O13:O18),IF(B17<>B13+1,SUMIF(K13:K17,"Rig
11",O13:O17),IF(B16<>B13+1,SUMIF(K13:K16,"Rig
11",O13:O16),IF(B15<>B13+1,SUMIF(K13:K15,"Rig
11",O13:O15),IF(B14<>B13+1,SUMIF(K13:K14,"Rig
11",O13:O14),SUMIF(K13,"Rig 11",O13))))))))

Please help, if you comprehend my question.

I don't understand what are you trying to do...

Mybe you could upload an example file to www.savefile.com or to
www.rapidshare.de


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy