How to create a function

[galsaba]

I have the a table with the following fields:
Invoice Number
Ammunt
State
Month

I want to add a new worksheet that will summerize the total amount by
state, by Month.
Do I need to create a VBA Macro, are there built in functions to do
the above?

Thanks

galsaba

 

[Guest]

Try a Pivot Table.

 

[galsaba]

This is the soluion. Works Great! Thanks!!

Try a Pivot Table.