numbers treated as text giving wrong values in index and sumifs

Vote count:

0

I'm indexing a table that somehow has numbers stored as text, here is a fragment:

{0\0\0\0\"110"\950\0\0\0\"3485"\0\0\0\"950"\0\0\0\0\0\100}

When I try to use sumifs for this range, i get wrong values. Is there any way to fix this in formula without changing the data?

This is the exact formula I'm using:

SUMIFS(INDEX(INDIRECT("'"&"P_"&$C$3&"'!B9:BC100");MATCH($D6;INDIRECT("'"&"P_"&$C$3&"'!BC9:BC100");0););INDIRECT("'"&"P_"&$C$3&"'!B1:BC1");L$1))

asked 1 min ago

Shatas

1

numbers treated as text giving wrong values in index and sumifs