LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35
Default COUNTIF for date and amount

I am looking for a function to find money values within certain ranges and
within certain date ranges:

Here is what the data I will get will look like

A B
$15 1/12/10
$20 7/5/07


I understand how to count gifts by the dollar amount range using countif,
but I don't know how to create or add the date range.

Thanks a lot for your help,
-B

 
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
Sum or count date then amount pgarcia Excel Discussion (Misc queries) 6 February 28th 09 10:23 PM
How can I link data in three different cells? ck# date amount Shiela Excel Worksheet Functions 2 November 13th 08 06:09 PM
Combining Date and Amount stew Excel Discussion (Misc queries) 4 September 21st 08 12:06 PM
How to retrieve last date and amount from columns? tfrentz Excel Worksheet Functions 5 October 30th 06 03:49 AM
any formular to deduct an amount automatically on a given date? Arif Excel Discussion (Misc queries) 1 January 15th 06 05:32 PM


All times are GMT +1. The time now is 07:33 AM.

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"