Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Ranges Q
How could I create a formula that will add up all the instances in
K10:K22 which are <blank if a not zero value is entered in the corresponding cells in J10:J22 eg. If J10 = <blank, then my answer would be 0 eg if J10 = 123 and J19 = 123 and K10 = <blank and K19 = Mon, then my answer would be 1 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Ranges Q
=SUM(IF((ISBLANK(K10:K22))*(J10:J22<0),1,0))
CTRL+SHIFT+ENTER this formula as it is an array-formula On 15 Sty, 16:43, Seanie wrote: How could I create a formula that will add up all the instances in K10:K22 which are <blank if a not zero value is entered in the corresponding cells in J10:J22 eg. If J10 = <blank, then my answer would be 0 eg if J10 = 123 and J19 = 123 and K10 = <blank and K19 = Mon, then my answer would be 1 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Ranges Q
=SUMPRODUCT(--(K10:K22=""),--(J10:J22<0))
-- __________________________________ HTH Bob "Seanie" wrote in message ... How could I create a formula that will add up all the instances in K10:K22 which are <blank if a not zero value is entered in the corresponding cells in J10:J22 eg. If J10 = <blank, then my answer would be 0 eg if J10 = 123 and J19 = 123 and K10 = <blank and K19 = Mon, then my answer would be 1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count the number between age ranges | Excel Discussion (Misc queries) | |||
Count age ranges | Excel Worksheet Functions | |||
count age ranges | Excel Discussion (Misc queries) | |||
count if in two ranges | Excel Discussion (Misc queries) | |||
count date ranges | Excel Worksheet Functions |