Previous Topic Next Topic

If condition

Closed
Divya - Jan 25, 2010 at 08:51 AM
 Trowa - Jan 26, 2010 at 07:39 AM
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 response

Answer 1 / 1
Trowa
Jan 26, 2010 at 07:39 AM
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
0

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Excel - IF function with multiple words
Nick -
user -

14 responses
Formula for if cell contains word, assign value for multiple
hdiesel -
ac3mark -

1 response
If cell contains multiple text how to add other cell value?
Iza -
TrowaD -

1 response