# sumif function not giving the correct total

## sumif function not giving the correct total

I'm trying to add the total product sold by a group of sales person for example : Chad + Javier. My actual worksheet includes 600 rows of salespeople and 20 rows of product, I'm using this simple example to get the message across.

I was using =sum(sumif(A1:A9,"Chad',D1:D9),sumif(A1:A9,"Javier",D1:D9)), the formula should have given 91, but instead is calculating 113.

Balers Person Product A Product B Product C

Visit publisher's web-site: sumif function not giving the correct total

## Related Tutorials

### Sumif giving a value even if there is no data

In the attached sheet SUMIF is giving a value even if there is no criteria. And the value changes on the no. of cells I select for the calculation. I have tried help but could not get an answer. please suggest.

### sum of digits in column not giving correct sum

My column of numbers is not giving the correct total. My formula for the total is: =ROUND(SUM(A4:A15),2) The numbers I added are 6.30+1.74+1.24 and got an answer of 9.27 (should be 9.28). The numbers I am adding are formulated from another macro not just a number I inserted (it is a formula to calculate the gst out of a number from another column) and this is why I think I am getting a wrong answer but I don't know how to correct it.

### Using a string function within a range in SUMIF -- possible?

Is it possible to use SumIf with a string function in the range? Example is if I have these columns and I also have it attached in Excel:

001 - Total Cat1 12

001 - Total Cat2 43

001 - Total Cat3 44

002 - Total Cat1 43

002 - Total Cat2 66

002 - Total Cat3 89

003 - Total Cat1 23

003 - Total Cat2 11

003 - Total Cat3 23

Total Cat1 78

Total Cat2 120

Total Cat3 156

I'd need to do a Right string function on Column A to only compare the Right 10 characters but I'm not able to find a way to do this. Can this be done in the SUMIF Criteria Range without having to create a new column just to contain this info?

### How do you correct inaccurate sumif totals?

I use the sumif functions quite a bit, however, today I am getting an inaccurate total on my sumif formula. What is driving this? Is the file size a

### SUMIF Question

Can you do a range such as M4:O10? My spreadsheet let me put this in but it

is not giving me the correct value. I have a 1 in cell O4 and it is giving me a value of "0" for this formula.

=SUMIF('June08 Summary'!$E$4:$E$10,"DM",'June08 Summary'!M4:O10)

## Related Applications & Scripts

### Total visits counter scripts set

This set is intended to count the total number of unique visitors of your site by checking the referer IP addresses and display it as text. It contains 3 ready-to-use total visits counters using 3 different methods of displaying data:

-php include() directive;

-html iframe widget;

-javascript widget.

### ASP Dynamic Session Counter

A unique ASP Hit/Session Counter for your website. This counter dynamically self-updates while detecting numbers of individual users viewing your site as well as counting the total hits.

Features

- Detects total number of unique online user sessions.

- Records total visitors.

- Auto refreshes within seconds.

- Well documented.

- Easily able to be modified.

### Running Golden Pocket watch

A customizable pocket watch that gives the correct time (i.e if your computer is set at the correct time) . You can customize the background as well as the watch brand logo. For the latter you need to modify the Logo Movie Clip in the library. The photo itself has a transparent background and is 600px wide, which makes it suitable for any screen size (as usually you dont want to have it fill the screen entirely).

### PHP Debugger

Having the possibility to prove that an application is correct not just by looking at test results is a great step forward in development.

Think about the times you had a problem and couldn't debug and find a solution. Think about the effort you spend in searching a loop in a script you had to maintain!

PHPDebugger reformats your source with correct indentations, and with leading tabs. This is a good start to gain a good overview of the code you write or have to maintain.

### jQuery autocomplete callback function

I have spent a lot of time on creating a working callback function for the jQuery UI autocomplete plugin. Here is a working example: