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
Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
Conditional formatting if another cell contains - Excel Forum
Conditional formatting if two cells match ✓ - Excel Forum
Excel add row if condition met - Excel Forum
Available memory less than 15mb condition zero - Guide

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

How to copy a data from one sheet to another, when specific criteria is met

Highlight cell if another cell contains specific text

Merge rows if it meets criteria in Excel

Similar discussions

Subscribe To Our Newsletter!