Formula Help Please?

[Danny Boy]

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

 

[T. Valko]

One way...

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

 

[Don Guillett]

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

 

[Mike H]

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.