Or was that question different? As I said on that other thread, option 3 is definitely a viable option. If it doesn't work and has been correctly implemented then it means that the underlying data is numbers stored as text rather than numbers. If you're still having trouble then I suggest you zip and attach the workbook...
The formatting of the cells doesn't change the underlying data types which are what I think are causing the problem: if that SUMIF() formula I posted on the other thread is returning zero then I think the numbers in your table are actually strings. In one column, as a test, try amending the lookup formulas so that there is a 0+ at the start, eg:
=0+LOOKUP(2,1/(('Call Status'!$A$1:$A$100="Last name, First Name")
*('Call Status'!$D$1:$D$100="Left Message")),'Call Status'!$G$1:$G$100)
The reason for doing this is that adding a zero to the lookup result will coerce it from text (string data type) to a number (double data type).
Then, here's that SUMIF() formula again for reference: