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
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