There are some quick techniques for filling blank cells he
http://www.contextures.com/xlDataEntry02.html
Or, add a column, and calculate the group there.
For example, in cell C1, enter: =IF(A2<"",A2,C1)
Copy the formula down to the last row of data.
Use the new column in your subtotal formula.
Stan wrote:
I need to use SUMIF to calculate a subtotal of column B based on the criteria
of column A. The problem is, the column A has names of group in every 10th
cell or so, and column B has many repeated numbers which could vary month to
month.
Example)
Col A Col B
group A a
b
c
group B a
b
c
d
I need subtotals for group A & B, even when group A has "d" listed in Col. B
in other months.
Please help. Thanks.
Stan
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html