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

If condition
Available memory less than 15mb condition zero - Guide
If condition in excel - Guide
Conditional formatting if two cells match ✓ - Excel Forum
Vba copy data from one sheet to another if a condition is met - Excel Forum
How to disable a cell in excel based on condition ✓ - Excel Forum

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

Similar discussions

How to use conditional format based on text?

Excel - IF function with multiple words

Highlight cell if another cell contains specific text

Merge rows if it meets criteria in Excel

Highlight cell if another cell contains any text

Similar discussions

Subscribe To Our Newsletter!