Dec 05 2017
03:28 AM
- last edited on
Jul 25 2018
10:32 AM
by
TechCommunityAP
Dec 05 2017
03:28 AM
- last edited on
Jul 25 2018
10:32 AM
by
TechCommunityAP
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.
Dec 05 2017 04:06 AM
SolutionRajesh,
neither function will help.
=COUNTIFS(B1:B200,"bobby",A1:A200;TODAY())
Dec 05 2017 04:06 AM
SolutionRajesh,
neither function will help.
=COUNTIFS(B1:B200,"bobby",A1:A200;TODAY())