Forum Discussion

Rajesh Kumar Bhupal's avatar
Rajesh Kumar Bhupal
Copper Contributor
Dec 05, 2017
Solved

Countif and if function

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...
Formulas & Functions
Need Help
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Dec 05, 2017

    Rajesh,

     

    neither function will help.

    =COUNTIFS(B1:B200,"bobby",A1:A200;TODAY())
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Dec 05, 2017

Rajesh,

 

neither function will help.

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

Resources