=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