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: 1
Default Formula to add based on information from 2 different cells

I am trying to create a formula that will take data from one column and based
upon that data count data in another column. My column C2:C112 holds state
names (FL) and my column H2:H112 holds dates (12/8/08). The formula needs to
count the number of dates in column H for all corresponding rows in column C.
So if I have 10 rows in column C with FL in it and only 3 with dates in
column H I only want it to add those 3 on a separate worksheet.
 
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
cell formula for using progressive information in other cells EG Excel Worksheet Functions 5 September 5th 08 03:43 PM
Is there a way to hide worksheets and/or rows/columns based on information enter into a particular cell of range of cells? Marc New Users to Excel 1 March 10th 06 05:10 PM
formula based on text information Kathryn W Excel Worksheet Functions 2 September 5th 05 12:12 AM
HOW DO I HAVE A CELL DISPLAY INFORMATION BASED ON 2 OTHER CELLS CC Excel Worksheet Functions 1 August 12th 05 05:34 AM
Is there away to have specific cells unlock based on the entry of information in another? Marc New Users to Excel 2 April 17th 05 06:09 PM


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