Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Here's a simplified example of what I want to do:
Col A Col B Row 1 yes 5 Row 2 10 Row 3 yes 15 Row 4 yes 20 What is the formula that will automatically find all numbers in Col B that have a corresponding "yes" in Col A, then SUM them and multiply by 30% ? If done manually, the final result would then be the equivalent of =(5+15+20)*.30, which is 12. Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Which function will shorten IF-THEN-ELSE ? | Excel Worksheet Functions | |||
Is there away to shorten | Excel Worksheet Functions | |||
Can I shorten this any? | Excel Worksheet Functions | |||
Any way to shorten this up? | Excel Worksheet Functions | |||
Shorten A Name | Excel Discussion (Misc queries) |