#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default countif - sumif

am looking to count a number of cells containing the same data in a row but
only if the individual cells fall within a certain date range


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default countif - sumif

Use the countifs in excel 2007.
H12:14 range you want to evaluate
(range 1, test 1, range 2, test 2)
=COUNTIFS($H$12:$H$14,"<3/1/09",$H$12:$H$14,"1/1/09")

If using excel 2003 use sumproduct:

=SUMPRODUCT((range1<reference last date)*(range2<reference first date))
=SUMPRODUCT(($H$12:$H$14<H14)*($H$12:$H$14H12))


"emmbee" wrote:

am looking to count a number of cells containing the same data in a row but
only if the individual cells fall within a certain date range


Reply
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
Sumif / Countif Blue Excel Worksheet Functions 3 May 15th 09 03:50 PM
COUNTIF?? SUMIF?? Vegs Excel Discussion (Misc queries) 1 December 19th 05 04:52 PM
Countif and sumif Visual Excel Discussion (Misc queries) 19 August 10th 05 05:59 PM
{} SumIf and CountIf SS Excel Worksheet Functions 5 May 24th 05 09:19 PM
Countif, Sumif reno Excel Worksheet Functions 2 February 12th 05 03:31 AM


All times are GMT +1. The time now is 06:39 PM.

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

About Us

"It's about Microsoft Excel"