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 / May 2008

Tip: Looking for answers? Try searching our database.

Nested Functions in Excel2003

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
BDUB - 21 May 2008 00:24 GMT
HELP!!!  

I am trying to create a function that identifies how many times a particular
cell value shows up between dates, then add up the frequency.  I have two
separate functions, that I would like to combine into one.

=COUNTIF(Data!A:A,A26)

=COUNTIF(Data!G:G,">=01/01/08")-COUNTIF(Data!G:G,">=01/31/08"))))

-I know that the first half will check the A column in the Data sheet, and
count it if the value matches on the 'index' sheet.

-I know that the second half of this will give me the instances for how many
times a value of January 08 occurs in Data column G.

However, I am trying to count ONLY the value in A26, that occur in January 08.

Any help would be appreciated!

BDUB
Teethless mama - 21 May 2008 02:45 GMT
=SUMPRODUCT(--(A1:A100=A26),--(TEXT(G1:G100,"m/yyyy")="1/2008"))

You can not use whole columns prior to Excel 2007

> HELP!!!  
>
[quoted text clipped - 17 lines]
>
> BDUB
 
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.