Counting non-zero cells based on date

[Guest]

Can someone please help with this? I can't seem to figure it out. Say I
have one column with a list of dates and another with values that are either
zero or non-zero. How do I count the number of nonzero cells in the second
column after today?

For example:
Column B Column C
3/20/2007 6.5
3/21/2007 0.0
3/22/2007 3.2
3/23/2007 7.8

If today is 3/20/2007 I want Excel to only count the values in Column C for
3/21-3/23 that are non-zero

 

[Guest]

try
=sumproduct(--(B1:B100>today()),--(C1:C100<>0))

 

[Guest]

Thanks a lot! That worked. Now I just have to figure out why it worked lol