Remember Me?

#1
May 22nd 05, 12:24 AM
 A. Toczko Posts: n/a

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!

#2
May 22nd 05, 12:43 AM
 Ron Rosenfeld Posts: n/a

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((D1100="apple")*(E1:E100={5,6,7,8}))

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

--ron
#3
May 22nd 05, 12:44 AM
 Ron Coderre Posts: n/a

Try this:

F1: =SUMPRODUCT(--((E1:E1000)={5,6,7,8})*(D11000="apple"))
(Note: Commit that formula by just pressing [Enter].

If 1000 rows isn't enough, just change that reference.

Does that hellp?
--
Regards,
Ron

#4
May 22nd 05, 12:52 AM
 Bob Phillips Posts: n/a

=SUMPRODUCT(--(D1100="apple"),--((E1:E100=5)+(E1:E100=6)+(E1:E100=7)+(E1:E
10
0=8)))

--

HTH

RP
(remove nothere from the email address if mailing direct)

"A. Toczko" wrote in message
...
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!

#5
May 22nd 05, 12:55 AM
 Bob Phillips Posts: n/a

or ...

=SUMPRODUCT((D110="apple")*(E1:E10={5,6,7,8}))

--

HTH

RP
(remove nothere from the email address if mailing direct)

"A. Toczko" wrote in message
...
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!

#6
May 22nd 05, 01:42 AM
 A. Toczko Posts: n/a

Thank you very much.

"Ron Coderre" wrote in message
...
Try this:

F1: =SUMPRODUCT(--((E1:E1000)={5,6,7,8})*(D11000="apple"))
(Note: Commit that formula by just pressing [Enter].

If 1000 rows isn't enough, just change that reference.

Does that hellp?
--
Regards,
Ron

#7
May 22nd 05, 08:55 AM

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!

Definitely faster to OR with the IsNumber|Match idiom:

=SUMPRODUCT(--(\$D\$2:\$D\$400="Apple"),--ISNUMBER(MATCH(\$E\$2:\$E\$400,{5,6,7,8},0)))

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post [email protected] Excel Worksheet Functions 19 May 11th 05 09:48 AM Luke Excel Worksheet Functions 37 May 6th 05 07:21 AM PutFormula Excel Worksheet Functions 2 February 11th 05 03:31 AM norcalchick2207 Excel Discussion (Misc queries) 2 February 4th 05 08:38 PM Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 04:37 PM

All times are GMT +1. The time now is 04:16 AM.