SUMIF works for PProd1 but not BA criteria !!

[carol]

Hi , Im confused !!!

I have the SUMIF working perfectly if I have the criteria
as prod1, prod2....but it doesn't count the totals if I
change that exact data to BA, CRW or whatever.

I've done a LINK PASTE into another file. Then split one
column from CRW,10 into 2 columns (type & mins). Now I
want to total the CRW mins and the other types minutes.
(Types are BA, BAD, BAW, CRW)

But try as I do ... I can't get the types totals.
Yet when I 'test' the SUMIF using Prod1, prod2 it works!!

I really can't see what I'm doing wrong. Can somehelp
please.
Cheers
Carol

 

[Carol]

Had a thought .. is it because the totals I want to add
have come for a LEFT .. that it's not being treated as a
NUMBER format.
Went and formated the column to NUMBER ... still no totals
in the SUMIF. damn.

 

[Govind]

Hi,

Can you paste your formula which is not working so that we can
troubleshoot?.Also tell me the range where the data is available.

Regards

Govind.

 

[Don Guillett]

Hi , Im confused !!!
Me too.
Perhaps you need to give us a lot more explanation.

 

[RagDyeR]

Sounds like you are extracting numbers with text functions, and then trying
to add them.

The text functions will return text that may look like numbers, not numeric
numbers, no matter what format the column might be.

If that's the case, simply coax the text to true numbers by adding the unary
to the beginning of your extraction formulas.

For example:
A1 - 123ABC
A2 - 456DEF

In B1 enter:
=--LEFT(A1,3) <Note the 2 minus signs after the = sign>
And copy down.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Had a thought .. is it because the totals I want to add
have come for a LEFT .. that it's not being treated as a
NUMBER format.
Went and formated the column to NUMBER ... still no totals
in the SUMIF. damn.