COUNTIF with 2 conditions

[Africa]

Hello

Version: 2003

I'd like to COUNTIF(A:A,"123") but only if the date in Column E falls within each 1/4 of the year. I'm trying to extract a figure for each 1/4 of the year.

Could I get the formula to refer to a dates table i.e 01/04/2011, 01/07/2011, 01/10/2011, 01/01/2012 - COUNTIF(A:A,"123")*(IF(<dates table)??? Can't get it to work!!

Any help would be great.

[zbor]

For XL2003 you can use SUMPRODUCT:

=SUMPRODUCT(--($A$2:$A$1000=123), --($E$2:$E$1000>="1.1.2012"), --($E$2:$E$1000<"1.4.2012")

Note:
- it's better to use smaller range (i.e. E1:E100 or something) than full column E:E
- all ranges must be same size (A2:A1023, E2:E1023 etc)
- Instead of dates you can use cell references (i.e. E1)

[Africa]

Zbor, thanks for the help but I can't get this to work. I'm using;

=SUMPRODUCT(A1:A35="123")*(E1:E35<I31) I31 being the date - it's not picking up the correct figure. Any idea's?

[zbor]

=sumproduct((a1:a35="123")*(e1:e35<i31))

[Africa]

Great thanks, much appreciated.