I IHAVE THIS TABLE:

A B C D E
_______________________________
1 dogs cats birds fish
2 here 2
3 there 1
4 up 3
5 down 4


And need a formula to output this:
2 dogs
1 cats
3 birds
4 fish

=SUM(B2:B5)&" "&B1&CHAR(10)&SUM(C2:C5)&" "&C1&CHAR(10)&SUM(D2:D5)&"
"&D1&CHAR(10)&SUM(E2:E5)&" "&E1

and format for WordWrap..........all on one line

Vaya con Dios,
Chuck, CABGx3



" wrote:

I IHAVE THIS TABLE:

A B C D E
_______________________________
1 dogs cats birds fish
2 here 2
3 there 1
4 up 3
5 down 4


And need a formula to output this:
2 dogs
1 cats
3 birds
4 fish

Thanks, that was easier than it looked.

You're welcome............yeah, sometimes they look pretty scary at first,
but when you break them down they're not so bad...........

Vaya con Dios,
Chuck, CABGx3



wrote in message
ups.com...
Thanks, that was easier than it looked.