Issue with SUMIF

Hi all, I'm using the SUMIF formula in a spreadsheet I created to pick out information based on a combination of 3 user defined dropdowns. I've assigned each line in the data a name based on region/site/calltype/time. Now it seems to be functioning for all the dropdown choices but one. The formula looks like this:

Please Login or Register  to view this content.

That one works, however if you switch that last group from F:F to G:G which should just make it sum the next column over, it starts adding up numbers that dont exist. I cannot for the life of me figure out why it would do that, it's the exact same formula just changing the sum targets. Using the same parameters as the previous column it somehow finds more valid columns than it did originally?

Any help would be greatly appreciated.

Looks like even zipped with best compression it's too large a file to post on here


USOremMainbank0.291666666666667

There's an example of the naming for a line of data.

The user can select between All regions US and Phillipines, then one of the 11different locations, then one of the calltypes. If they choose the "All" selections in the dropdowns it is recognized as a wildcard.

The specific problem i'm seeing comes when the output would look like *Orem*0.29166666... There's only one section of the data that matches that criteria. When I do this for column F:F it works fine, for G:G it does not. If I change the dropdowns to show *OremMainbank0.291666... it will show the proper data.

Originally Posted by NBVC

The Sumif() function recognizes the "*" as a wildcard you are probably getting data for all text that contains "Orem" followed by any value and ending with 0.29166666.

Right, that's what that should be showing however it isn't. In the data set there is only one cell that matches the criteria of orem 0.2916666. In fact for the F:F column it works fine, that cell shows a value of 4 and that's what the formula finds. Move it over one column and magically the 0 is turned into a 40.

Ok I cut out a large majority of the sheet but this should give an example of what I'm experiencing here.

argh, sneaky. I dont suppose there's a way around that short of altering the names a bit to make it work.