Countif and if function

[Rajesh Kumar Bhupal]

Hi ,

i would like to have a formula to count the repeatations time of name bobby in a column B1:B200, if the date in the columns A1:A200 contains today's date.

I tried the countif and if in a nested way but something is wrong.

[#2 · Accepted solution]

Rajesh,

neither function will help.

=COUNTIFS(B1:B200,"bobby",A1:A200;TODAY())

[#3]

THANK YOU SO MUCH..