SOLVED

Countif and if function

New Contributor

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 Replies
best response confirmed by Rajesh Kumar Bhupal (New Contributor)
Solution

Rajesh,

 

neither function will help.

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

THANK YOU SO MUCH..