View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Karen Smith Karen Smith is offline
external usenet poster
 
Posts: 45
Default # of days - if & count statements

I need to create 2 formulas on the following table ....1 how many records are
0-30 days (answer 4) and 2ndly how much money are in 0-30 days (answer $750)

For example
# of Days $
28 150
34 100
22 100
44 100
1 200
32 50
5 300