Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT
HI,
Can someone help me please? Cell "L21" needs a total of following; If code "BC" is found in range "B14:B391", find value from "H14:H391" and then multply with a percentage rate in "A1" Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT
=VLOOKUP("BC",B14:H391,7)*A1
assuming that A1 is already a percentage -- Gary''s Student - gsnu200839 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT
=SUMPRODUCT(--(B14:B391="BC"),(H14:H391))
will give you the SUM for rows having BC in Col B Multiply it with A1 to get the percentage like this =(SUMPRODUCT(--(B14:B391="BC"),(H14:H391)))*A1 Use =(SUMPRODUCT(--(B14:B391="BC"),(H14:H391)*A14:A391)) If you have percentages in A14:A391 for each row "MIK" wrote: HI, Can someone help me please? Cell "L21" needs a total of following; If code "BC" is found in range "B14:B391", find value from "H14:H391" and then multply with a percentage rate in "A1" Thank you. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT
Hi,
Try: =SUMIF(B14:B391,"BC",H14:H391)*A1 -- If this helps, please click the Yes button. Cheers, Shane Devenshire "MIK" wrote: HI, Can someone help me please? Cell "L21" needs a total of following; If code "BC" is found in range "B14:B391", find value from "H14:H391" and then multply with a percentage rate in "A1" Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
SUMPRODUCT | Excel Worksheet Functions | |||
SUMPRODUCT | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Can Sumproduct do this? | Excel Worksheet Functions |