Formula to load data from one sheet to another works in Excel 2016 but not 2010

Hi,

I created the attached sheet in Excel 2016 and it works great, but when I take it to my parents PC (Excel 2010) the formulas dont work.

I simply want to add an entry on the Daily Stocktake sheet and it will add or subtract from the totals on the Inventory sheet. I'm assuming the formula I've used is not supported in the older version of Excel.

Any help or advice would be greatly appreciated.

Thanks,

Aarron

Deleted, Aarron2 complied with both requests. Thank you!

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

use =IF(C13="","",SUM(D13:F13)) isnsted of D13+E13+F13

I didn't see any other formula with error there

if the value is the issue then try this... =IF(C13="","",SUM(D13,E13,-F13))
that returns a 0, I think Sandy just missed that you were subtracting F13.

LOL, Sambo kid, you are right

just because of football match Espania vs Russia

if you only have one criteria for a sumif you don't need a sumifs.
in E7 of the stock inventory sheet you are trying to sum what is in D7:D399 by matching your stock reference from C7 to the stock reference in the daily stock take.
sumifs is for more than one criteria while sumif is for one set of criteria. But either sumif or sumifs should work in 2010.

So the sumifs is looking for values but there aren't any that meet your criteria.

It looks like sumifs began in 2013.
but for one criteria you only need sumif and that works in 2010 as well as 2016.

Oops, I found this on Microsoft support about sumifs...
https://support.office.com/en-us/art...6-611CEBCE642B

Applies To: Excel for Office 365, Excel for Office 365 for Mac, Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2016 for Mac, Excel for Mac 2011, Excel Online, Excel for iPad, Excel Web App, Excel for iPhone, Excel for Android tablets, Excel for Android phones, Excel Mobile, Excel Starter 2010

so it should also work in 2010.

This is the sumifs you have...
=IF(B7="","",SUMIFS('Daily Stocktake'!D$7:D$399,'Daily Stocktake'!C$7:C$399,C7))
this is the sumif you need...
=IF(B7="","",SUMIF('Daily Stocktake'!C$7:C$399,C7,'Daily Stocktake'!D$7:D$399))

I just edited my post #13 for the formula you need.
BUT, either should return a value, your sample sheet didn't contain any values in col D of the daily stocktake for the formula to return.