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 nested way but something is wrong.

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())

Resources