Formula Help Please?
 

I'm trying to figure out the best formula to resolve the following:

A B C
Name Jan. Feb

1 Barb 8 3
2 Group 4 5
3 Ernest 6 7
4 Group 7 9
5 Heidi 9 4
6 Group 4 8
7 Total ____ ______

What we are trying to accomplish, is a formula that totals the values in
column "B", however, those values which are "group" (B2, B4 & B6) should be
multipled by 34%, while those values which are not group (B1, B3, & B5) are
totaled at 100% of their value (merely added up). We'll be doing this
spreadsheet over a 12 month period, however, I only gave examples for Jan and
Feb to display what I'm trying to accomplish. Any help would be appreciated.

Thanks in advance,

Dan

Formula Help Please?
 

One way...

=SUMPRODUCT((A2:A7<"group")*B2:C7)+SUMPRODUCT((A2 :A7="group")*B2:C7)*0.34

--
Biff
Microsoft Excel MVP


"Danny Boy" wrote in message
...
I'm trying to figure out the best formula to resolve the following:

A B C
Name Jan. Feb

1 Barb 8 3
2 Group 4 5
3 Ernest 6 7
4 Group 7 9
5 Heidi 9 4
6 Group 4 8
7 Total ____ ______

What we are trying to accomplish, is a formula that totals the values in
column "B", however, those values which are "group" (B2, B4 & B6) should
be
multipled by 34%, while those values which are not group (B1, B3, & B5)
are
totaled at 100% of their value (merely added up). We'll be doing this
spreadsheet over a 12 month period, however, I only gave examples for Jan
and
Feb to display what I'm trying to accomplish. Any help would be
appreciated.

Thanks in advance,

Dan

Formula Help Please?
 

try this in Jan total and drag across the other columns
=SUM(B2:B7)-SUMIF($A2:$A7,"group",B2:B7)*0.64

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Danny Boy" wrote in message
...
I'm trying to figure out the best formula to resolve the following:

A B C
Name Jan. Feb

1 Barb 8 3
2 Group 4 5
3 Ernest 6 7
4 Group 7 9
5 Heidi 9 4
6 Group 4 8
7 Total ____ ______

What we are trying to accomplish, is a formula that totals the values in
column "B", however, those values which are "group" (B2, B4 & B6) should
be
multipled by 34%, while those values which are not group (B1, B3, & B5)
are
totaled at 100% of their value (merely added up). We'll be doing this
spreadsheet over a 12 month period, however, I only gave examples for Jan
and
Feb to display what I'm trying to accomplish. Any help would be
appreciated.

Thanks in advance,

Dan

Formula Help Please?
 

Hi,

Try this and drag right for other months

=(SUMIF($A$2:$A$7,"Group",C2:C7)*0.34)+SUMIF($A$2: $A$7,"<Group",C2:C7)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Danny Boy" wrote:

I'm trying to figure out the best formula to resolve the following:

A B C
Name Jan. Feb

1 Barb 8 3
2 Group 4 5
3 Ernest 6 7
4 Group 7 9
5 Heidi 9 4
6 Group 4 8
7 Total ____ ______

What we are trying to accomplish, is a formula that totals the values in
column "B", however, those values which are "group" (B2, B4 & B6) should be
multipled by 34%, while those values which are not group (B1, B3, & B5) are
totaled at 100% of their value (merely added up). We'll be doing this
spreadsheet over a 12 month period, however, I only gave examples for Jan and
Feb to display what I'm trying to accomplish. Any help would be appreciated.

Thanks in advance,

Dan