# Sumifs total in cell different to Function Argurments Box

#### PatPat

##### Board Regular
Hiya

As per the attached pic my formula {=SUMIFS(Sheet3!D:D,Sheet3!A:A,">42099",Sheet3!A:A,"<42466")+SUMIF(Sheet3!E:E,"Cost of sales: Food",Sheet3!D:D)} shows an incorrect result of -4608.75
in the spreadsheet cell but a correct result of -5163.6 in the Function Arguements Box.

Can anyone suggest what the problem is?

Thanks in anticipation

Image - TinyPic - Free Image Hosting, Photo Sharing & Video Hosting

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

#### steve the fish

##### Well-known Member
The -5000 is the result of the sumif formula not the two formulas added together.

#### PatPat

##### Board Regular
The -5000 is the result of the sumif formula not the two formulas added together.

Hi Steve

Thanks but that is not the problem.

The -5163.6 result is actually the correct result if i sum the cells in question manually according to the criteria.

#### steve the fish

##### Well-known Member
Put each formula in a separate cell. What are the results?

Replies
6
Views
179
Replies
1
Views
488

1,191,517
Messages
5,987,059
Members
440,074
Latest member
Emmanuelian

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back