Countifs with either OR

[ahmedlala]

Folks,

I have a quick question,

Column 1 Column2 Column 3
A 1/02/2013 1/01/2013
B 2/02/2013 2/01/2003
C 3/12/2012 3/01/2013
C 1/02/2013 12/12/2013
A 2/02/2013 23/03/2012
F 3/12/2012 4/05/2012
B 1/02/2013 1/04/2013
H 2/02/2013 2/03/2013


Thought of using Countifs to

- count cells in column1 containing A or C or F
- Count all corresponding cells in Columns 2 & 3 containing dates before 1/1/13

Can you please help.

Thanking you in advance.

[Ace_XL]

Do you mean..

=SUM(COUNTIFS($A$1:$A$8,{"A","C","F"},$B$1:$B$8,"<"&DATE(13,1,1),$C$1:$C$8,"<"&DATE(13,1,1)))

[XOR LX]

Hi,

=SUMPRODUCT((ISNUMBER(MATCH(A2:A9,{"A","C","F"},0))*((B2:B9<DATEVALUE("01/01/2013"))+(C2:C9<DATEVALUE("01/01/2013")))))

Regards

[XOR LX]

I read it as counting all dates less than 01/01/2013, whether they occur in column B or column C.

Apologies if this is not correct.

Regards

[ahmedlala]

Thanks all for you help

[Debraj Roy]

We are glad.. that you came back.. and feedback the response..

Here Memebers work hard.. (without any pay) to solve other's query..
Your feedback's is the only payment that they expect..

If the query is solved.. Please mark the thread as Solved.. May be you will not able to do this.. as 2 day passed.. Just post here.. a line with Solved...

ADMIN / MOD will do that for you..

[ahmedlala]

SOLVED!

Thank you very much! the responses I got were great and very helpful, Appreciate all the help I received from all those that have contributed.

kind regards