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