LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
K K is offline
external usenet poster
 
Posts: 108
Default Countif using multiple references

hey guys please help me out.

I have a flat file that has start date in column a, and end date in column b
and data in columns c - h. I want to count the data in range c-h but only if
the start and end dates in column a and b are within a certain date parameter.

I have read differnt answers here using countif and also sumproduct but I'm
not sure what the argument should be or the syntax.

could you please help out?


 
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
Transposing Multiple Cell References to Multiple Values (NOT total LinLin Excel Discussion (Misc queries) 7 November 11th 07 10:57 PM
Transposing Multiple Cell references as Multiple Values LinLin Excel Discussion (Misc queries) 1 November 8th 07 01:21 AM
CountIf does not work with an Absolute references GG Excel Discussion (Misc queries) 2 November 4th 07 03:41 PM
wildcard in countif formula that uses cell references Terry Freedman Excel Discussion (Misc queries) 2 November 2nd 07 05:28 PM
Cell references in a countif function? WildlyHarry Excel Discussion (Misc queries) 6 August 9th 07 04:37 PM


All times are GMT +1. The time now is 09:05 AM.

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"