 |
 | 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 / Worksheet Functions / November 2005count on condition / Formula
Q1: I want to count how many of many data is under "panel" and in in "yellow" colour. when I use =COUNTIF(A1:B6,"panel") it works and =COUNTIF(B2:B7,"yellow")) it also works but how to combine this two? Q2: some answer I saw posted =SUMPRODUCT(--(A1:A100="example"),--(B1:B100=2)). what is the "--" to be replaced with? appreciate your answer. thanks in advance. -- shouldn't be replaced with anything. Is your first range really A1:B6 or A1:A6, if the latter then just use =SUMPRODUCT(--(A1:A6="panel"),--(B2:B7="yellow"))  SignatureHTH RP (remove nothere from the email address if mailing direct) > Q1: I want to count how many of many data is under "panel" and in in "yellow" > colour. when I use =COUNTIF(A1:B6,"panel") it works and [quoted text clipped - 5 lines] > > appreciate your answer. thanks in advance. |
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
|
©2009 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.