F
F J
Hi, I have a several large spreadsheets which have data that is broken
into groups. Each of these groups needs a running total within its
own group. I had some similar spreadsheets the other day and someone
here gave me a great formula that worked on those using the data in
column A as the criteria for a SUMIF formula:
=IF(A1="","",SUMIF($A$1:A1,A1,$B$1:B1))
The problem with these new files is that unlike the other ones, there
is nothing that is always unique about the data in each group that
could be used for a SUMIF formula or something like that. The only
indication that the data should even be in separate groups is that
each group is separated by a blank row. The data is set up like
this. The running totals formula would appear in column C:
Column A Column B Column C
Apples 100 100
Apples 200 300
Apples 500 800
Apples 300 300
Apples 100 400
Oranges 200 200
Oranges 300 500
Oranges 500 500
Pears 300 300
Pears 200 500
Apples 200 200
Apples 500 700
Is there any way to create a formula that can just be copied all the
way down the column instead of having to go through and change it for
each group? Thank you in advance for any help or information.
into groups. Each of these groups needs a running total within its
own group. I had some similar spreadsheets the other day and someone
here gave me a great formula that worked on those using the data in
column A as the criteria for a SUMIF formula:
=IF(A1="","",SUMIF($A$1:A1,A1,$B$1:B1))
The problem with these new files is that unlike the other ones, there
is nothing that is always unique about the data in each group that
could be used for a SUMIF formula or something like that. The only
indication that the data should even be in separate groups is that
each group is separated by a blank row. The data is set up like
this. The running totals formula would appear in column C:
Column A Column B Column C
Apples 100 100
Apples 200 300
Apples 500 800
Apples 300 300
Apples 100 400
Oranges 200 200
Oranges 300 500
Oranges 500 500
Pears 300 300
Pears 200 500
Apples 200 200
Apples 500 700
Is there any way to create a formula that can just be copied all the
way down the column instead of having to go through and change it for
each group? Thank you in advance for any help or information.