Hello again!
I'm using a sumproduct forumla to count rows based on specific data in multiple columns. So if column A equals 1 and column G does not equal 6 and column M equals 4 then count that row. I know how to do this. The problem I'm having is that I want to count column A if equals 1 or 2. I tried adding an OR comand in with my sumproduct but it doesn't seem to work that way. Any ideas? Thanks
Last edited by Cjax; 07-23-2009 at 01:24 PM.
=sumproduct(--(a1:a4=1)+(a1:a4=2),--(g1:g4<>6),--(h1:h4=4))))
Last edited by martindwilson; 07-23-2009 at 12:47 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
It worked alright but I can't follow the logic behind it at all. Can you explain why it works. Im not familar with using -- in formulas or why you placed them where you did. Thanks again
-- simply changes true/false to 1/0
same as using
g1:g4<>6)*(h1:h4=4) in which true *true =1 true*false=0
So I can use
)*( or ,-- interchangeably?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks