Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro creation help | Excel Programming | |||
Macro creation | Excel Worksheet Functions | |||
Creation of macro with an example | Excel Discussion (Misc queries) | |||
Macro Creation | Excel Discussion (Misc queries) | |||
XML creation via a macro | Excel Programming |