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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIFS error 1
Sumif formula 4
SUMIFS for rows 1
SUMIF & OR 6
Sumif number is greater than a number but less than another number 2
Sum number range ignoring numbers formatted as text 0
sumif with 2 variables 2
Weekday and Sumif 3

Back
Top