Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 22nd 05, 12:24 AM
A. Toczko
 
Posts: n/a
Default 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!



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

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   Report Post  
Old May 22nd 05, 12:44 AM
Ron Coderre
 
Posts: n/a
Default

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   Report Post  
Old May 22nd 05, 12:52 AM
Bob Phillips
 
Posts: n/a
Default

=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   Report Post  
Old May 22nd 05, 12:55 AM
Bob Phillips
 
Posts: n/a
Default

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   Report Post  
Old May 22nd 05, 01:42 AM
A. Toczko
 
Posts: n/a
Default

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   Report Post  
Old May 22nd 05, 08:55 AM
Aladin Akyurek
 
Posts: n/a
Default

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)))


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
referencing named formula using INDIRECT function [email protected] Excel Worksheet Functions 19 May 11th 05 09:48 AM
Simplify formula Luke Excel Worksheet Functions 37 May 6th 05 07:21 AM
put formula results into a different cell if it is empty PutFormula Excel Worksheet Functions 2 February 11th 05 03:31 AM
how do i write a formula and keep in in formula form, so it DOESN. norcalchick2207 Excel Discussion (Misc queries) 2 February 4th 05 08:38 PM
Match / Vlookup within an Array formula 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.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017