LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
jrheinschm
 
Posts: n/a
Default find sum if one col = ? within specific date range

A B C D E
1 1/21 1 10
2 2/15 2 5
3 3/24 1 10
4 4/15 2 20
5 5/18 1 10
6 6/10 1 10
7 7/8 1 5
8 8/12 2 5
9
Search for sum of column C if column B = 1 between the dates of 2/15 - 7/8:
=35
Probably another simple solution for this one. Thanks for the help.
 
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 items when specific text and date criteria are met javamom Excel Worksheet Functions 8 April 24th 06 09:28 PM
Date Range within one cell Cachod1 New Users to Excel 5 October 18th 05 03:30 AM
How do I sum a range if the date is is greater than today's date? S2 Excel Worksheet Functions 4 October 8th 05 08:11 PM
HELP - Date Range In 1 Cell Calculation Adam Excel Worksheet Functions 6 September 19th 05 08:24 PM
Date range criteria and Pivot tables (again!) DerbyJim1978 Excel Worksheet Functions 3 July 13th 05 10:14 PM


All times are GMT +1. The time now is 03:10 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"