I'm a novice with excel. I've used it very basically and am trying to expand the near limitless potential. I have a question. We have a spreadsheet with multiple inputs in different columns with assigned values. I'd like to be able to tally each common input and value over the entire sheet. As well as have the ability to add different variables to the summary column. Thanks for any and all help.[TABLE="width: 500"]
<tbody>[TR]
[TD]A
[/TD]
[TD]40
[/TD]
[TD]A
[/TD]
[TD]40
[/TD]
[TD]B
[/TD]
[TD]50
[/TD]
[TD]Total inventory
[/TD]
[TD]sum
[/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]50
[/TD]
[TD]C
[/TD]
[TD]20
[/TD]
[TD]A
[/TD]
[TD]23
[/TD]
[TD]A
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C
[/TD]
[TD]10
[/TD]
[TD]D
[/TD]
[TD]50
[/TD]
[TD]C
[/TD]
[TD]10
[/TD]
[TD]B
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]E
[/TD]
[TD]35
[/TD]
[TD]S
[/TD]
[TD]45
[/TD]
[TD]E
[/TD]
[TD]12
[/TD]
[TD]C
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]X
[/TD]
[TD]34
[/TD]
[TD]S
[/TD]
[TD]22
[/TD]
[TD]Z
[/TD]
[TD]12
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D
[/TD]
[TD]22
[/TD]
[TD]A
[/TD]
[TD]12
[/TD]
[TD]W
[/TD]
[TD]10
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
<tbody>[TR]
[TD]A
[/TD]
[TD]40
[/TD]
[TD]A
[/TD]
[TD]40
[/TD]
[TD]B
[/TD]
[TD]50
[/TD]
[TD]Total inventory
[/TD]
[TD]sum
[/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]50
[/TD]
[TD]C
[/TD]
[TD]20
[/TD]
[TD]A
[/TD]
[TD]23
[/TD]
[TD]A
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C
[/TD]
[TD]10
[/TD]
[TD]D
[/TD]
[TD]50
[/TD]
[TD]C
[/TD]
[TD]10
[/TD]
[TD]B
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]E
[/TD]
[TD]35
[/TD]
[TD]S
[/TD]
[TD]45
[/TD]
[TD]E
[/TD]
[TD]12
[/TD]
[TD]C
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]X
[/TD]
[TD]34
[/TD]
[TD]S
[/TD]
[TD]22
[/TD]
[TD]Z
[/TD]
[TD]12
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D
[/TD]
[TD]22
[/TD]
[TD]A
[/TD]
[TD]12
[/TD]
[TD]W
[/TD]
[TD]10
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]