I think a better way to consider what I'm looking for might be: how many
times was a bid accepted three consecutive days (or four days, five days or
'x' number of days). The countif does help though, thank you.

"nuver" wrote:


Hello
Use the countif function. You will want to select your range and then
in the criteria box enter "Y" if you want to count the number of times
the bid was accepted.


--
nuver
------------------------------------------------------------------------
nuver's Profile: http://www.excelforum.com/member.php...o&userid=10036
View this thread: http://www.excelforum.com/showthread...hreadid=378220