Sumif

S

Sum Problem

I'm finding @sumif is not summing all numbers in a range. Does the
criteria have to be in a certain format? I believe I've fixed all format
discrepancies. Any other suggestions?
 
J

J.E. McGimpsey

Regardless of format, if some of your numbers were entered as Text,
then they remain text and won't be counted. To coerce text numbers
to real numbers, copy an empty cell, select your numbers, choose
Edit/Paste Special, selecting the Values and Add Radio buttons.
 
P

Peo Sjoblom

Post your formula

--

Regards,

Peo Sjoblom

I'm finding @sumif is not summing all numbers in a range. Does the
criteria have to be in a certain format? I believe I've fixed all format
discrepancies. Any other suggestions?
 
Top