LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JM JM is offline
external usenet poster
 
Posts: 37
Default Count and/or sum data within a date span.

Need help with this function - cannot get it to work.
All records in the file have a purchase transaction date and a purchase
amount. I want to, for example, get a count of all transactions for the
month of August 2007. I also want to total the amounts for that month. The
data in the DATE column is entered as "xx/xx/xxxx".
--
JM
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
count the mean in few date but on de date it has various data LinSeang Excel Worksheet Functions 1 June 30th 06 02:12 PM
Importing Text File Data into Excel where records span several row Razorback76 Excel Discussion (Misc queries) 2 June 25th 06 06:36 AM
Count/Sum data with date entries. KBW Excel Worksheet Functions 6 April 5th 06 07:32 PM
Count multiple data by date Racorfrank Excel Worksheet Functions 3 October 30th 05 04:11 AM
Count data entries and date problem Gef Excel Worksheet Functions 5 November 4th 04 02:30 PM


All times are GMT +1. The time now is 11:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"