Hello,
I cannot get my head to figure out the right formula to find a total for "Sum of Yes" in Table 1 in the example below. The sum of yes for DC (row 2) should be 4500.00 since column Bob and Column Ted for DC are yes, Florida is 5702.00, etc.
Thanks for any suggestions!
Table 1
State...