| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to sum one column using a second column as a condition
I have a budget management with rows indicating employee "time
entries". The sheet has columns: date client project employee billed time (min) description of work charge type Underneath the "time entries" is a "summary section" with columns charge type total min their are 6 charge types em bar bas sam saa sad How can I make the "total time" field in the summary section automatically calculate the total minutes for each of the 6 charge types given? ie. if I have: date client project employee billed time (min) description charge type 09/26/06 client 1 project 1 smith 30 description of some task EM 10/19/06 client 2 project 2 smith 30 description of some task EM 09/26/06 client 1 project 1 smith 100 description of some task BAR 10/19/06 client 5 some project smith 100 description of some task BAR 09/26/06 client 6 some project jones 100 description of some task BAR 10/19/06 client 5 some project smith 45 description of some task BAS 09/26/06 client 2 some project smith 45 description of some task BAS 10/19/06 client 3 some project davis 60 description of some task SAM 09/26/06 client 3 some project smith 60 description of some task SAM 10/19/06 client 4 some project smith 60 description of some task SAM 10/19/06 client 7 some project davis 60 description of some task SAA 09/26/06 client 8 some project smith 30 description of some task SAA 10/19/06 client 10 some project smith 15 description of some task SAA 10/19/06 client 3 some project davis 10 description of some task SAD 09/26/06 client 2 some project smith 25 description of some task SAD 10/19/06 client 2 some project smith 30 description of some task SAD the summary will show : charge total min em 60.00 bar 300.00 bas 90.00 sam 180.00 saa 45.00 sad 65.00 I am hoping that there is some way to associate some VBA code with each "total min" fields (for each "charge type") that will automatically find time entry rows with a given charge type, total them all up and then show the total in the summary. I appreciate any help you can provide. Thanks, Alex |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to sum one column using a second column as a condition
=SUMIF(G:G,"em",E:E)
etc. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Alex" wrote in message ups.com... I have a budget management with rows indicating employee "time entries". The sheet has columns: date client project employee billed time (min) description of work charge type Underneath the "time entries" is a "summary section" with columns charge type total min their are 6 charge types em bar bas sam saa sad How can I make the "total time" field in the summary section automatically calculate the total minutes for each of the 6 charge types given? ie. if I have: date client project employee billed time (min) description charge type 09/26/06 client 1 project 1 smith 30 description of some task EM 10/19/06 client 2 project 2 smith 30 description of some task EM 09/26/06 client 1 project 1 smith 100 description of some task BAR 10/19/06 client 5 some project smith 100 description of some task BAR 09/26/06 client 6 some project jones 100 description of some task BAR 10/19/06 client 5 some project smith 45 description of some task BAS 09/26/06 client 2 some project smith 45 description of some task BAS 10/19/06 client 3 some project davis 60 description of some task SAM 09/26/06 client 3 some project smith 60 description of some task SAM 10/19/06 client 4 some project smith 60 description of some task SAM 10/19/06 client 7 some project davis 60 description of some task SAA 09/26/06 client 8 some project smith 30 description of some task SAA 10/19/06 client 10 some project smith 15 description of some task SAA 10/19/06 client 3 some project davis 10 description of some task SAD 09/26/06 client 2 some project smith 25 description of some task SAD 10/19/06 client 2 some project smith 30 description of some task SAD the summary will show : charge total min em 60.00 bar 300.00 bas 90.00 sam 180.00 saa 45.00 sad 65.00 I am hoping that there is some way to associate some VBA code with each "total min" fields (for each "charge type") that will automatically find time entry rows with a given charge type, total them all up and then show the total in the summary. I appreciate any help you can provide. Thanks, Alex |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to sum one column using a second column as a condition
thank you! it works perfectly.
-alex Bob Phillips wrote: =SUMIF(G:G,"em",E:E) etc. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Alex" wrote in message ups.com... I have a budget management with rows indicating employee "time entries". The sheet has columns: date client project employee billed time (min) description of work charge type Underneath the "time entries" is a "summary section" with columns charge type total min their are 6 charge types em bar bas sam saa sad How can I make the "total time" field in the summary section automatically calculate the total minutes for each of the 6 charge types given? ie. if I have: date client project employee billed time (min) description charge type 09/26/06 client 1 project 1 smith 30 description of some task EM 10/19/06 client 2 project 2 smith 30 description of some task EM 09/26/06 client 1 project 1 smith 100 description of some task BAR 10/19/06 client 5 some project smith 100 description of some task BAR 09/26/06 client 6 some project jones 100 description of some task BAR 10/19/06 client 5 some project smith 45 description of some task BAS 09/26/06 client 2 some project smith 45 description of some task BAS 10/19/06 client 3 some project davis 60 description of some task SAM 09/26/06 client 3 some project smith 60 description of some task SAM 10/19/06 client 4 some project smith 60 description of some task SAM 10/19/06 client 7 some project davis 60 description of some task SAA 09/26/06 client 8 some project smith 30 description of some task SAA 10/19/06 client 10 some project smith 15 description of some task SAA 10/19/06 client 3 some project davis 10 description of some task SAD 09/26/06 client 2 some project smith 25 description of some task SAD 10/19/06 client 2 some project smith 30 description of some task SAD the summary will show : charge total min em 60.00 bar 300.00 bas 90.00 sam 180.00 saa 45.00 sad 65.00 I am hoping that there is some way to associate some VBA code with each "total min" fields (for each "charge type") that will automatically find time entry rows with a given charge type, total them all up and then show the total in the summary. I appreciate any help you can provide. Thanks, Alex |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting entries in column based on condition in another column | Excel Worksheet Functions | |||
| adding numbers from column B, while condition on column A | Excel Discussion (Misc queries) | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| how to count a column based on condition of another column | Excel Worksheet Functions | |||
| Enter a formula in column A, if a condition in column "B" is met | Excel Programming | |||
![Alex[_33_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
