Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help w/ SUMPRODUCT
I had great feedback when I was trying to figure out an equation for teh
following example: Of the people in column 'A' who identified as a "2", what percentage also identified as a "5" in column 'B'? -- And I received this equation from more than one person. =sumproduct(--(a2:a99=2),--(b2:b99=5)) BUT, I am actually trying to find all the people in 3 columns who identified as a "2" (lets say columns X,Y, and Z, rows 4 thru 100) who also identified as a "5" in column E, rows 4:100. When I only do one column, it works -- =sumproduct(--(W4:W100=2),--(E4:E100=5)) but when I add other columns, it does not. How do I put that into the equation? I've tried a few different things, but none are working. I get VALUE errors, NAME errors, and plain old "you did something very wrong" errors. :) I don't know how to do multiple columns and I don't know entirely where anything goes in regard to parenthesis and funny dashes. :) Thank you very much! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
sumproduct | Excel Discussion (Misc queries) | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Sumproduct | Excel Worksheet Functions |