Forum Discussion
concatenate and if statements
please tell me how to paste my file into message
Hi Steve,
Adding the post please use Choose Files button below the window to attach the file.
Sorry to be so much trouble Sergei. Message window has no choose file button. Has only a browse button through which I can select my file but doesn't open in the message window.
Steve, no problem.
With browsing in opened window select your file and click Open. After that selected file name appears near the button, nothing else happens. Click on Post after that.
If you want to detach the file (before you click on Post) click again on Choose Files and without selecting any file click Open.
Don't know if you will see the file , but here goes. You will see a monthly calendar with columns of 4 weeks with room for the occasional 5th. I am using =countif($d2:$d45,WkrTable!$a$20) which works fine.
Below the calendar section, you will see two sections of rows, one called worship team, and one called ministry team. The similar countif for the worship team section works fine as team A is always on Week 1, B on Week 2, C on Week 3. The problem is the ministry teams as the 5 teams create a rotating lineup. eg Raymond's team is not always on Week 1. I am trying to automate the worksheet so in any one week I can count how many duties each person has. So far I've got one formula for the calendar columns, one for the worship team rows, and one for the ministry team rows, but because of the ministry rotating lineup the combined formulas become horribly complex.
I thought I could use concatenate, in which each individual formula could reside in a cell so that the formula could read
=concatenate(cell1, " + ", cell2, " + ", cell3)
but this produces the VALUE! error message.