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: 9
Default countif with two sets of non consectutive ranges at the same time

I need to count how many times 10 appears in a row. but the row has been
split up. the data is in a1:f1 then more in m1:z1. the countif function
will not let me have more than one consectuive stretch for its range.

any suggestions

 
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
Comparign two sets of time schedules to fidn best matches Sean Timmons Excel Worksheet Functions 0 December 19th 06 01:01 AM
Two Sets of Time Data - One Chart lmeg Charts and Charting in Excel 0 August 7th 06 12:10 PM
countif with non-continous ranges Debbie Excel Worksheet Functions 7 May 10th 06 09:00 PM
Countif between ranges BSantos Excel Discussion (Misc queries) 1 February 15th 06 05:52 PM
how do i import multiple data sets at one time? chris_rip Excel Discussion (Misc queries) 3 June 22nd 05 04:27 AM


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