Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif on 2 different rows
I have 2 different rows with different values in 6 columns set up as such
Row 1: 110010 Row 2: 502345 I am trying to write a formula to count the instances where row 2 is 0 and row 1 = 1 So in this instance, row 2 0 in all but the second column (column B); row 1 = 1 in columns A, C and E Therefore, the total could be 2 b/c both criteria are meant in column A and E Help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif on 2 different rows
=SUMPRODUCT(--(A1:Z1=1),--(A2:Z20))
-- Regards, Peo Sjoblom "kd5000" wrote in message ... I have 2 different rows with different values in 6 columns set up as such Row 1: 110010 Row 2: 502345 I am trying to write a formula to count the instances where row 2 is 0 and row 1 = 1 So in this instance, row 2 0 in all but the second column (column B); row 1 = 1 in columns A, C and E Therefore, the total could be 2 b/c both criteria are meant in column A and E Help? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif on 2 different rows
Try this:
=SUMPRODUCT(--(A1:F1=1),--(A2:F20)) -- Biff Microsoft Excel MVP "kd5000" wrote in message ... I have 2 different rows with different values in 6 columns set up as such Row 1: 110010 Row 2: 502345 I am trying to write a formula to count the instances where row 2 is 0 and row 1 = 1 So in this instance, row 2 0 in all but the second column (column B); row 1 = 1 in columns A, C and E Therefore, the total could be 2 b/c both criteria are meant in column A and E Help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF in between rows | Excel Worksheet Functions | |||
Countif rows | Excel Discussion (Misc queries) | |||
Using COUNTIF with visible rows only | Excel Worksheet Functions | |||
countif() help for multiple rows | Excel Worksheet Functions | |||
countif() help for multiple rows | Excel Worksheet Functions |