| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to sum a set of number with criteria "SW/**" as a subtotal
Need to sum a set of number with criteria "SW/**" as a subtotal
Something like SUMIF(H2:H470) "SW?**", SUBTOTAL(9, J2:J40)) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to sum a set of number with criteria "SW/**" as a subtotal
What do you mean? Include in the sum everything that starts with SW/ ?
Or are you looking specifically for SW/** ? In the first case, =SUMIF(H2:H470,"SW/*",J2:J470) In the second case =SUMPRODUCT((H2:H470="SW/**")*J2:J470) HTH Kostis Vezerides kj108 wrote: Need to sum a set of number with criteria "SW/**" as a subtotal Something like SUMIF(H2:H470) "SW?**", SUBTOTAL(9, J2:J40)) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to sum a set of number with criteria "SW/**" as a subtota
I want to display the subtotal of a column of numbers if they are associated
with a group of people (using autofilter) whose criteriua in anbother column starts with SW/ hence "SW/**" Cheers, KJ "vezerid" wrote: What do you mean? Include in the sum everything that starts with SW/ ? Or are you looking specifically for SW/** ? In the first case, =SUMIF(H2:H470,"SW/*",J2:J470) In the second case =SUMPRODUCT((H2:H470="SW/**")*J2:J470) HTH Kostis Vezerides kj108 wrote: Need to sum a set of number with criteria "SW/**" as a subtotal Something like SUMIF(H2:H470) "SW?**", SUBTOTAL(9, J2:J40)) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to sum a set of number with criteria "SW/**" as a subtota
Then my first formulal will do:
=SUMIF(H2:H470,"SW/*",J2:J470) HTH Kostis Vezerides kj108 wrote: I want to display the subtotal of a column of numbers if they are associated with a group of people (using autofilter) whose criteriua in anbother column starts with SW/ hence "SW/**" Cheers, KJ "vezerid" wrote: What do you mean? Include in the sum everything that starts with SW/ ? Or are you looking specifically for SW/** ? In the first case, =SUMIF(H2:H470,"SW/*",J2:J470) In the second case =SUMPRODUCT((H2:H470="SW/**")*J2:J470) HTH Kostis Vezerides kj108 wrote: Need to sum a set of number with criteria "SW/**" as a subtotal Something like SUMIF(H2:H470) "SW?**", SUBTOTAL(9, J2:J40)) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need to sum a set of number with criteria "SW/**" as a subtota
But it doesn't.
It gives the same answer no matter which Manager of the group I pick in Autofilter. Which is why I wanted to put subtotal as: SUMIF(H2:H470) "SW/**", SUBTOTAL(9, J2:J470)) which doesn't work. Cheers, KJ "vezerid" wrote: Then my first formulal will do: =SUMIF(H2:H470,"SW/*",J2:J470) HTH Kostis Vezerides kj108 wrote: I want to display the subtotal of a column of numbers if they are associated with a group of people (using autofilter) whose criteriua in anbother column starts with SW/ hence "SW/**" Cheers, KJ "vezerid" wrote: What do you mean? Include in the sum everything that starts with SW/ ? Or are you looking specifically for SW/** ? In the first case, =SUMIF(H2:H470,"SW/*",J2:J470) In the second case =SUMPRODUCT((H2:H470="SW/**")*J2:J470) HTH Kostis Vezerides kj108 wrote: Need to sum a set of number with criteria "SW/**" as a subtotal Something like SUMIF(H2:H470) "SW/**", SUBTOTAL(9, J2:J40)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get the total number of items that meet 2 criteria in Exc | Excel Worksheet Functions | |||
| I Need to Count Number of Entries Based on Two Criteria | Excel Worksheet Functions | |||
| Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
| Is the data validation criteria limited to a few number of items . | Excel Worksheet Functions | |||
| How do I count the times a number occurs in a given criteria? | Excel Discussion (Misc queries) | |||
Linear Mode
