Forum Discussion
Steve Haines
Dec 28, 2017Copper Contributor
formulas and functions
I am creating a spreadsheet describing responsibilities of members of my church for each Sabbath meeting of the month. Consequently 4 or 5 columns each month. Want to double check my entries so that...
Steve Haines
Dec 28, 2017Copper Contributor
thank you Sergei for helping. This is kind of fun figuring out this stuff. Let's suppose the following:
column B is job descriptions from B2:B37. Column C is week 1 called 1/6/2018. Entered in C2:C37 are various peoples names.
I think the formula is =countif(b$2:b$37[1/6/2018],Raymond) but its not working. Where is my error?
Maybe it should say =countif(c$2:c$37,raymond)
SergeiBaklan
Dec 28, 2017Diamond Contributor
Hi Steve,
Yes, in this variant
=countif(c$2:c$37,"Raymond")