I'm just wondering how a formula would work where I am wanting Column A says "X" where the same rows in Column B says "Y"?
This is for 500 datasets and I require the answer to be displayed in another column, which appears on a different worksheet, not sure if this affects the formula much.
Thanks
=countifs(a1:a500,"=x",b1:b50,"=y") should do it
mind you just
=countifs(a1:a500,"x",b1:b50,"y") should work
Last edited by martindwilson; 09-10-2012 at 06:17 AM.
"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
Deleted post.
Last edited by Kevin UK; 09-10-2012 at 06:14 AM.
Hello,
My first attempt would be trying to do a COUNTIF formula combining those two variables.
If that first attempt would fail, do 2 separate countif's and add them in one unic formula using the "+"(add) between them. Such as:
COUNTIF(A:A;"X") + COUNTIF(B:B;"Y")
If you're not sucessfull provide a file so I can have a look.
EDIT: I was too late
Kind Regards,
FCarv
Try
=sumproduct(--(a:a="x")*--(b:b="y"))
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
Thanks all for the quick replies.
Countifs worked perfect.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks