# countif condition with date

1. ## countif condition with date

I Have A Column A,b, And C

A-----b--c
Jan-1 X P
Jan-2 X P
Jan-3 X E
Jan-4 X Q
Jan-5 X E
Jan-6 X Q

1st Problem:
I Want To Count B=X To C=P&E And I Dont Want To Count B=X & C=Q
Total Is 4
2nd Problem I Want To Count Base On The Covered Date
I Want To Count From Jan 1 To Jan 4 Only B=X To C=P&E
Total Is 3

God Speed!!!!

2. I assume your data is in cells a1:c6

1st Problem:
I Want To Count B=1 To C=1&2 And I Dont Want To Count B=1 & C=3
Total Is 5

=sumproduct((b1:b6=1)*(c1:c6<3))

2nd Problem I Want To Count Base On The Covered Date
I Want To Count From Jan 1 To Jan 4 Only B=1 To C=1&2
Total Is 3

presumably your "dates" are in fact dates and not text - and are in the year 2005

=sumproduct((a1:a6>=datevalue(1/1/2005))*(a1:a6<=datevalue(1/4/2005))*(b1:b6=1)*(c1:c6<3))

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1