anything in Excel...

It's Excel-o-lozy...

"Sumif" not calculating right values in the formula.

www.Excelolozy.comSometimes the formula Sumif or Sumifs doesn’t calculate right values.
The reason of error can be the criteria for which value is to be calculated.

Problem:
Check if following characters are being used as text in your data..

'*' or '<' or '>'

e.g.
“>10” if used in criteria as text then it won’t capture right totals.

Diagnose:
It happens because Excel considers these wild characters as operators as ‘Operators’.

Solution:
1.       Either replace these characters with some Alpha-numeric values
-          e.g. “Greater than 10”
2.       Use these characters at any place other than the first place in the text
-          e.g. “10<”
3.       Insert space before that character
-          e.g. “ <10”

Anything in Excel, be an Excelolozian...

for best MS Excel Tips visit http://www.Excelolozy.com

gotta query??? drop a mail at mail@excelolozy.com