| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column totals depending on different criteria
Good Morning, and a hearty Monday to all of you.
I have a worksheet with a lot of columns. In one of the columns (lets say A) I have the name of the piblications, in B I have the dates on which the ads appear, and in column C I have the cost per insertion. There is a line in between 2 different publications. The information looks something like this: Column A Column B Column C Pub 1 11th nov 500 Pub 1 12th nov 500 Pub 1 17th nov 500 Pub 1 18th nov 500 Pub 2 19th nov 300 Pub 2 24th nov 400 Pub 3 11th dec 500 Pub 3 12th dec 500 Pub 3 14th dec 500 The number of Publications vary in every file. I was wondering if someone could help with a macro to add the cost per insertion in column C, so that I get the total cost per publication in the blank row. Thanks, Prash |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count/Sum rows of a column depending on criteria from drop-down li | Excel Worksheet Functions | |||
| Charting depending on criteria & data series name as a column val | Charts and Charting in Excel | |||
| I want to add totals using several criteria from different column | Excel Discussion (Misc queries) | |||
| How do I add totals from a range of dates depending on the month? | Excel Worksheet Functions | |||
| Calculating totals depending on cell value | Excel Programming | |||
Threaded Mode
