Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / August 2006

Tip: Looking for answers? Try searching our database.

Conditional Count 2 Columns

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
rileym - 22 Aug 2006 21:01 GMT
I will post the two formulas I am using now and I hope someone can help
me figure out how to make it into 1.  Thanks in advance.

#1               =COUNTIF(location, "shop")    total=20
#2               =COUNTIF(date,">"&B10)-COUNTIF(date,">"&B11)
total=10

Explained(as the best I can)

#1 It simply counts the number of times that the "Shop" was used all
months
#2 Counts the total number of times that "All" were used for a
particular month.

Goal

I want to be able to count how many times the "Shop" was used in each
particular month.  I have the "Shop total" and the "All by month" but
was looking to get "Shop by each month"

Thanks in advance

Signature

rileym

Joerg - 23 Aug 2006 03:54 GMT
> I will post the two formulas I am using now and I hope someone can help
> me figure out how to make it into 1.  Thanks in advance.
[quoted text clipped - 17 lines]
>
> Thanks in advance

Please have a look at array formulas
(http://www.cpearson.com/excel/array.htm)
This technique is much more powerful than single COUNTIFs.

Joerg
 
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.