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? |
Countif on 2 different rows
If you have more than one set of criteria to check, its generally best to use
SUMPRODUCT instead. For your example, try this: =SUMPRODUCT(--(A1:F1=1),--(A2:F20)) HTH, Elkar "kd5000" wrote: 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? |
All times are GMT +1. The time now is 05:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com