View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
needexcelhelp needexcelhelp is offline
external usenet poster
 
Posts: 5
Default Compare the value of one cell to 2 different cells

Hi,
I need some help. I'm trying to do the following without having to count
cells then adding them in different work sheets. Please let me know if my
explantion is not good.

I want to sum up the total number of instances that falls within a date
range. For example, if value in the A column is = B1 AND <= B2 then C1 =
C1+1

A B C
1 12-1-2008 12-1-2008
2 12-8-2008 12-8-2008
3 10-1-2008
4 12-5-2009
5 12-1-2008