Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|