View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
kyoko kyoko is offline
external usenet poster
 
Posts: 9
Default need help in formula

sorry i posted the same problem with the first one 'coz i thought my first
post didn't appear here...its just the same...hope someone help me here...

"kyoko" wrote:

i really need help for this one:

A B C
oct 27 -50 cover
oct 27 -50 not cover
oct 27 50 cover
oct 28 150 cover
oct 28 -100 cover
oct 29 -50 cover

in this case, i need the number of "cover" from oct 27 to oct 29 that falls
under -50 only. is there any way to make it easier for me to get the number
of it? please help me..i will appreciate it a lot..thanks in advance