best way to..?

  • Thread starter Thread starter PBcorn
  • Start date Start date
P

PBcorn

i have a list of data with row labels like this:

a c
a x
a n
a y
b c
b x
b n
b y

just want to know the simplest way to add rows c,n for a and b, then delete
rows c and n for a and b, then insert two new rows containing c+n. Tried cut
and paste with xlAdd but this is messy. Also thought of using arrays, but
this could be more long winded while avoiding the problems i am having with
copy/paste.
 
A sumproduct formula usually will work


=sumproduct(--($A:$A="a"),--($B:$B="c"),$C:$C)+sumproduct(--($A:$A="a"),--($B:$B="n"),$C:$C)+sumproduct(--($A:$A="b"),--($B:$B="c"),$C:$C)+sumproduct(--($A:$A="b"),--($B:$B="b"),$C:$C)
 
Thanks but i was looking for a macro solution as i need to insert two new
rows showing the sums.
 
Back
Top