Remember Me?

 A. Toczko Posts: n/a formula help please

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!

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

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

--ron
 Ron Coderre Posts: n/a Try this:

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

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

Does that hellp?
--
Regards,
Ron

 Bob Phillips Posts: n/a =SUMPRODUCT(--(D1 100="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!

 Bob Phillips Posts: n/a or ...

=SUMPRODUCT((D1 10="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!

 A. Toczko Posts: n/a Thank you very much.

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

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

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

Does that hellp?
--
Regards,
Ron 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)))

 Thread Tools Search this Thread Show Printable Version Search this Thread: Advanced Search Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 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. Copyright ©2004-2020 ExcelBanter.