Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm trying to get the percentage of times that an is able to meet assigned
goals accross multiple rows and columns. What I've come up with after more time than I care to admit is below. Cany anyone help me with this? ={SUMPRODUCT(($C$2:$C$34="Persons Name")*($E$2:$E$34<F2:F34)*($I$2:$I$34<$J$2:$J$34* (M2:M34<N2:N34)/COUNT(IF(($C$2:$C$34="Persons Name"),$E$2:$F34,I2:I34,M2:M34))))} |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
countif / sumproduct or something else? | Excel Discussion (Misc queries) | |||
Sumproduct and Countif together | Excel Discussion (Misc queries) | |||
Sumproduct and Countif | Excel Discussion (Misc queries) | |||
COUNTIF or SUMPRODUCT? | Excel Worksheet Functions | |||
SUMPRODUCT & COUNTIF | Excel Worksheet Functions |