Macro Creation
 

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!

Macro Creation
 

Seems like a pivot table should work for you. Look at these tutorials:
http://peltiertech.com/Excel/Pivots/pivottables.htm
http://www.babeled.com/2008/07/18/ex...-manipulation/


HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Liz J" wrote:

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!

Macro Creation
 

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

"ryguy7272" wrote:

Seems like a pivot table should work for you. Look at these tutorials:
http://peltiertech.com/Excel/Pivots/pivottables.htm
http://www.babeled.com/2008/07/18/ex...-manipulation/


HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Liz J" wrote:

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!