You are here: HomeExcelTutorials

# sumif function not giving the correct total

## sumif function not giving the correct total

Price: FREE

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

Category and Tags: ExcelTutorials :

## Related Tutorials

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

Free: Yes
Tags: Excel ›

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

Free: Yes
Tags: Excel ›

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?

Free: Yes
Tags: Excel ›

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?

Free: Yes
Tags: Excel › Functions

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

Free: Yes
Tags: Excel ›

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

Free: Yes
Tags: PHP › Excel Counters

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

Free: No

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

Free: No
Tags: Flash › Excel Animations

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

Free: Yes
Tags: PHP › Excel Error Handling

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

Free: Yes
Tags: Ajax › Excel Auto Complete jQuery

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