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))

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))

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))

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))

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))