Thread: countif for two column condition

hi,

I would need help with following problem in Excel XP.

I have in column A dates and in column B percent

I would need in another cell a formula which give me number of "rows" where is date (in column A) later then today and percent (B) is smaller than 100%.

Is it possible? I don't want to make Column C where would be - if(and(A>today;B<100%);1;0) and then summ of column C

Thank You in advance

Martin

Perhaps =sumproduct((A1:A100>today())*(B1:B100<1))

Adapt ranges to your needs