LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 184
Default Count If formula with week range

I am trying to write a count if formula to count the total in A1:A3 and count
it to what is in B4:7 in D on if the date in B1:B3 falls in the range of the
date given in D2 and on. Examples below

Thank you for the help



A B C
1 NBC 4/20/09 7865.42

2 NBC 3/28/09 1268.42

3 NBC 4/22/09 1000.00



A D E F
1 Week Start Week Start Week Start

2 3/30/09 4/13/09 4/27/09
4 NBC 1268.42 8865.42





 
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
formula to count charcter in a range Dylan @ UAFC[_2_] Excel Worksheet Functions 11 January 15th 09 04:52 AM
How t count by week whatever is with in the week (two criteria, ma Adnan Excel Discussion (Misc queries) 8 November 13th 06 09:17 AM
Count formula within a named range. PW11111 Excel Discussion (Misc queries) 2 July 19th 05 09:29 AM
Help with week day count with range Diane1477 Excel Worksheet Functions 6 June 29th 05 09:49 PM
Formula to count only positives in range Stadinx Excel Discussion (Misc queries) 3 June 14th 05 08:10 AM


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