On Sat, 21 May 2005 20:24:25 -0300, "A. Toczko" wrote:

Hello. In a spreadsheet, I want to count how many rows meet the following
conditions:
column D=apple and (column E=5 or column E=6 or column E=7 or column E=8).
Thank you!


If it does not need to be the ENTIRE column, then:

=SUMPRODUCT((D1:D100="apple")*(E1:E100={5,6,7,8}))

Adjust the range D1:D100 and E1:E100 to what is necessary.




--ron