 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2008Countif
Hi, Cell C12 has this formula: COUNTIF($E12:$AI12,$C$5) What modifications should be done so as it will count the values equal to C4 (in addition to C5). Khalil =SUMPRODUCT(SIGN(($E$12:$AI$12=$C$4)+($E$12:$AI$12=$C$5))) or if contiguous then =SUMPRODUCT(--(($E$12:$AI$12=$C$4:$C$5))) or =SUMPRODUCT(--ISNUMBER(MATCH($E$12:$AI$12,$C$4:$C$5,0)))  Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > Hi, > Cell C12 has this formula: COUNTIF($E12:$AI12,$C$5) > What modifications should be done so as it will count the values equal to > C4 (in addition to C5). > Khalil Hi, thank you very much. It was perfect. Khalil > =SUMPRODUCT(SIGN(($E$12:$AI$12=$C$4)+($E$12:$AI$12=$C$5))) > [quoted text clipped - 11 lines] >> C4 (in addition to C5). >> Khalil And, just in case you might like to use Countif(), try this: =SUM(COUNTIF($E12:$AI12,N(INDIRECT({"C4","C5"})))) SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > Hi, > thank you very much. It was perfect. [quoted text clipped - 16 lines] >>> to C4 (in addition to C5). >>> Khalil > Hi, > Cell C12 has this formula: COUNTIF($E12:$AI12,$C$5) > What modifications should be done so as it will count the values equal to C4 > (in addition to C5). > Khalil =COUNTIF($E12:$AI12, OR($C$5, $C$4)) Using the OR function will allow you to count multiple criteria. HTH, Matt Richardson http://teachr.blogspot.com May I suggest that you actually try your suggestion here, and your other one. Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) >> Hi, >> Cell C12 has this formula: COUNTIF($E12:$AI12,$C$5) [quoted text clipped - 10 lines] > Matt Richardson > http://teachr.blogspot.com > May I suggest that you actually try your suggestion here, and your other > one. [quoted text clipped - 21 lines] > > Matt Richardson > >http://teachr.blogspot.com Ignore my response earlier! I've answered two questions this morning about COUNTIFs and both were wrong. My head's just not screwed on right today LOL. Theres a couple of other ways of doing this here:- http://www.ozgrid.com/Excel/count-if.htm Regards, Matt Richardson http://teachr.blogspot.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.