ExcelBanter - How to create a function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to create a function (https://www.excelbanter.com/excel-worksheet-functions/128097-how-create-function.html)

galsaba

How to create a function

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

Gary''s Student

How to create a function

Try a Pivot Table.
--
Gary's Student
gsnu200702

"galsaba" wrote:

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

galsaba

How to create a function

This is the soluion. Works Great! Thanks!!

On Jan 28, 6:41 pm, Gary''s Student
wrote:
Try a Pivot Table.
--
Gary's Student
gsnu200702

"galsaba" wrote:
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- Hide quoted text -- Show quoted text -

All times are GMT +1. The time now is 01:59 AM.