Combining Totals on Successive Rows Based on Two Criterion

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

razorsharpe wrote:
> 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