Auto sum Function

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

use a Pivot Table. See

http://peltiertech.com/Excel/Pivots/pivotstart.htm


In article <0a7701c50568$b6e31440$a501280a@phx.gbl>,
"vibha" <anonymous@discussions.microsoft.com> 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
>

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