Macro Creation

[Liz J]

I'm looking to create a macro with a sumif function (among maybe other
functions) incorporated into the code. If you could please help, I would
appreciate it!
Here's what I'm looking at: in column A I have a list of items:
Selling Salaries
Store Manger Salary
Asst Manager Salary
Employee 1 Salary
Employee 2 Salary
Utilities
Phone - Regular
Internet
Postage
(etc, etc ...)
In Column B, I have the categories by which these items are assigned
Payroll
Payroll
Payroll
Payroll
Payroll
Office Overhead
Office Overhead
Office Overhead
Office Overhead
(etc, etc...)
In column C, I have all of the $ amounts associated with these costs.

I'd like these values in column C added together (probably best with sumif
formula) based off of their assigned categories. Then, if it's possible, I'd
like to consolidate the information in column A to read what the category is
in column B. So, the end product reading:
Column A
Salary
Overhead

Column B
$$ (sum for Salary)
$$ (sum for Overhead)

Thanks for your help!

 

[ryguy7272]

Seems like a pivot table should work for you. Look at these tutorials:
http://peltiertech.com/Excel/Pivots/pivottables.ht
http://www.babeled.com/2008/07/18/excel-pivot-table-tutorial-wizard-usage-and-basic-manipulation/


HTH,
Ryan---

 

[Liz J]

You're right. I overcomplicated it. Thanks, Ryan.