Forum Discussion
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...
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)
Hi Steve,
Yes, in this variant
=countif(c$2:c$37,"Raymond")