Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumproduct, lookup?
Hello. I am trying to avoid entering data on two different worksheets.
=SUMPRODUCT(--(B2:B100),--(B2:B10<=105)/COUNT(B2:B10)) How do I write the formula to look in column M for "b" then compute the sumproduct formula for that row? I want to avoid adding more columns to the worksheet. Thanks for your help. I am learning so much from this board! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumproduct, lookup?
What calculation do you want to perform on the row once you identify it?
Tom |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumproduct, lookup?
I want to calculate the percentage for when "b" apears in M2:M10
=SUMPRODUCT(--(B2:L100),--(B2:L10<=105)/COUNT(B2:L10)) a1 b2 c2 m2 111 b 99 s 200 s 110 b 50 b 99 s 225 b b % = 25% (0 and <=105 b2:l10) "TomPl" wrote: What calculation do you want to perform on the row once you identify it? Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct or lookup | Excel Worksheet Functions | |||
lookup and sumproduct | Excel Discussion (Misc queries) | |||
Sumproduct and horizontal lookup | Excel Discussion (Misc queries) | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
from sumproduct to a lookup please | Excel Worksheet Functions |