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
If condition in excel - Guide
Air condition lidl - Home - Apps & Sites
Available memory less than 15mb condition zero - Guide
Excel copy value if condition met ✓ - Excel Forum
If cell contains text then return value multiple conditions - 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

Highlight cell if another cell contains specific text

How to use conditional format based on text?

Excel - IF function with multiple words

Disable a cell in excel using VB code

If Statement in Excel that locks a cell

Similar discussions

Subscribe To Our Newsletter!