If condition

[Closed]
Report
-
 Trowa -
Hello,


I wanted to count rows marked as X (in column A) , where in x will not be continuous must compare with Column b which has date for Eg

Column A
1-Jan
1-Jan
1-Jan
1-Jan
1-Jan
1-Jan
1-Jan
1-Jan
1-Jan
1-Jan

Column B
x
0
x
x
0
x

Now i want the count of X for 1- Jan

1 reply

Hi Divya,

If you want to know how many rows contain both "1-jan" and "X" use the following array formula:

=SUM((A1:A6="1-jan")*(B1:B6="X"))
Confirm the formula by hitting Ctrl+Shift+Enter.

Adjust the ranges to match your data.

Best regards,
Trowa