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)




"PBcorn" wrote:

> 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.

Thanks but i was looking for a macro solution as i need to insert two new
rows showing the sums.

"Joel" wrote:

> 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)
>
>
>
>
> "PBcorn" wrote:
>
> > 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.