If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Count - if statement....
Hi,
I created a box called TXT_Completed for me to put ="Completed: " & Sum(IIf([Answer] like "1",1,0)) & " of " & Count (*) and it works. I have four groups and I want to set like below and I'm not able to make it work. ="Completed: IIf([GroupA] like "1",1,0)) & " of " & Count (*) and next one, ="Completed: IIf([GroupB] like "1",1,0)) & " of " & Count (*) I'm struggling last two A and B. Your help would be much appreciated. I don't know if I do the right thing. Thanks |
Thread Tools | |
Display Modes | |
|
|