This is basically where I keep landing. I can get part of the way there with my reports, I just can't get the totals to happen. Thanks for working through this with me!

Here is an updated spreadsheet that, hopefully, will make this more clear. (This is only a sampling of the options to make it more manageable for this purpose.) What I want to get to is a total count for each light blue option, so total of all Hospital 1 responses, total of all Hospital 2 responses,...

1) people are always going to have to fill out field A and B No. Field A would be required, but field B is optional. 2) However, fields 1-8 only appear based on the field A and B answers.Correct 3) still hazy on this one. You really just want an overall count over a number of tasks.e.g.task 1 = Fiel...

This might work. I'll give it a try.

I realize this is confusing. I'm sorry I'm struggling to explain it clearly.1. None of fields are multi-select.2. There is logic assigned for fields 1 - 8. So, for example, if Choice 1 is selected in Field A, Field 1 is another drop-down of choices. If Choice 1 is selected in Field B, Field 2 is ano...

Here is a visual that might help. What I'm looking for is a record count of each like answer from Field 1+2, Field 3+4, etc.

1) I want a total record count of the selections from Field 1 plus Field 2 (or 3 and 4)2) No, I only want the results of like choices in A and B. If A and B are different choices, it would only count the one choice.Not sure if that explains it clearly. 

I would like to create a report that will show the sum of record counts for multiple fields in a custom form. Specifically, something like this: If Field A or Field B = Choice 1, then show the total count of Field 1 plus Field 2. If Field A or Field B = Choice 2, show the total count of Field 3 plus...

This worked! Thank you!!!

I am trying to create a project view that will display the selections made in two dropdown fields in the custom form. I have no problem with the first column, but the second column is a problem. I'm hoping this is something that can be solved with text mode, but my text mode knowledge is extremely l...