Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
#3
|
|||
|
|||
Try this:
F1: =SUMPRODUCT(--((E1:E1000)={5,6,7,8})*(D1:D1000="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
|
|||
|
|||
=SUMPRODUCT(--(D1:D100="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
|
|||
|
|||
or ...
=SUMPRODUCT((D1:D10="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
|
|||
|
|||
Thank you very much.
"Ron Coderre" wrote in message ... Try this: F1: =SUMPRODUCT(--((E1:E1000)={5,6,7,8})*(D1:D1000="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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |