Sumif

  • Thread starter Thread starter Sum Problem
  • Start date Start date
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?
 
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.
 
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?
 
Back
Top