Forum Discussion

Steve Haines's avatar
Steve Haines
Copper Contributor
Dec 28, 2017

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...
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Dec 28, 2017

Hi Steve,

 

It depends on how exactly you'd like your data to be organized. As variant, one set with your duties in rows, weeks as columns and member names in cells. Another set is list of members in rows, weeks as columns and number of duties per week for each member.

 

If above as Excel tables with names "Duties" and "Members" when the formula in first week for members will be

=COUNTIF(Duties[w1],Members[@[Member]:[Member]])

, drag it to the right on another columns.

 

Same for ranges could be like

=COUNTIF(B$2:B$26,$H2)

to copy it down and to the right.

Please see attached file. 

 

Steve Haines's avatar
Steve Haines
Copper Contributor
Dec 28, 2017

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's avatar
    SergeiBaklan
    Diamond Contributor
    Dec 28, 2017

    Hi Steve,

     

    Yes, in this variant

    =countif(c$2:c$37,"Raymond")

     

Resources