View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
it would be much easier if you could fill column A completely with the group
name. Could you change this layout?

--
Regards
Frank Kabel
Frankfurt, Germany
"Stan" schrieb im Newsbeitrag
...
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