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

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