Customized Report Summary?

[timboy6]

Hello,

How can I create a button on a worksheet?

When pressed, it will look at a range (ex. a1-a6), which are predefined
names such as lodging, marketing, sales, etc. and sum them up?
I.E. there are 3 "lodging" entries and 3 "sales" entry and tell me that by
displaying the summary on h1-h6? And b1 - b6 is the amount in $$$ used for
the entry?

Example for summary:
So there are 3 lodging for a total of $4
and there are 3 Sales for $15

Example:
A B
(I would like a button here)
1 Lodging $2
2 Lodging $1
(Display my summary here)
3 Lodging $1
4 Sales $5
5 Sales $5
6 Sales $8

 

[Jacob Skaria]

I would suggest to have the summary displayed in another column; which will
auto change upon new entries to Col A and ColB. In Col C you enter the unique
entries..and D1 apply formula

=SUMIF(A:A,C1,B:B)
Copy down the formula to D2, D3....which will give you the total for each
head. Now try adding/editing/deleting entries to Col A/B


Col A Col B Col C Col D
Lodging $2 Lodging 4
Lodging $1 Sales 18
Lodging $1 Marketing 0
Sales $5
Sales $5
Sales $8

If this post helps click Yes

 

[timboy6]

Thank you Jacob!

It helped me, but do you know how I can add a button or something similar so
that when pressed it will display the summary?

Right now I have the summary working, but it is always displaying. It would
be nice if it only shows up when you tell it to, and is there a way also to
make the file menus to disappear when a user opens this workbook? Thanks!

 

[Jacob Skaria]

Try PIVOT table..

If this post helps click Yes

 

[timboy6]

I will give that a shot, thank you once again Jacob.

Tim