You can use sumif or sumproduct, I would personally use multiple sumif like

=SUMIF($A$2:$A$100,"Bill",B$2:B$100)

then copy across to cover all months then sum the line of sumif

or use

=SUMPRODUCT(($A$2:$A$100="Bill")*(B2:F100))


replace Bill with a cell where you put in the names

Regards,

Peo Sjoblom

"vibha" wrote:

> Hi,
>
> Could you please let me know how can I insert autosum
> function on a huge spreadsheet that has hundreds of
> multiple records in Name column. I want the value to
> return as Bill- in Jan had 106 calls, Feb had 16 and so
> forth for all clients
>
> Name Jan Feb Mar Apr May
> Bill 14 8 71 11 28
> Bill 29 4 18 93 26
> Bill 63 4 12 65 11
> Jack 15 8 63 12 9
> John 12 5 14 23 19
> John 4 7 1 29 23
> Sam 9 4 7 13 11
>
> Thanks
>
>