I'm trying to put this out there again because I still don't have a working resolution for this.

As shown in the screenshot, I need to sum these columns around the #N/As.
The cells all include the Lookup formula to pull other counts from another tab.

Whatever formula is used, it must be entered into the totals row.

I've tried a could of of other suggestions and they didn't work.

TIA!

MillB

I already provided a solution on your other thread here, right?
SUM column totals when there's #N/A

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...

Hi Colin,

Thanks for your help.
Yeah, I tried all those options and none of them worked.

The cells on the Lookup worksheet and in these columns are all formatted to number. I changed the range to above the total cells and I get zero in all.
??? See attachement.

Thanks again.

Like you said, it might be easier to attach the workbook. lol

Hiya,

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:
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:
Fingers crossed...

Colin ~

Thank you so much for your help!
Absolutely amazing. I added 0+ at the beginning of the LOOKUP formulas in each cell and add the SUMIF. SHAZAAM!

Thanks again

Great stuff, Mill.