SUMIF Doesn't return total amount?

Microsoft Office Forums

		Microsoft Office Forums > Microsoft Excel > Excel
SUMIF Doesn't return total amount?

Prev

Previous Post

Next Post

Next

#1

Old

12-11-2020, 03:02 AM

shabbaranks shabbaranks is offline

shabbaranks is offline

SUMIF Doesn't return total amount?

Windows 7 64bit SUMIF Doesn't return total amount?

SUMIF Doesn't return total amount?

Office 2007

Advanced Beginner

SUMIF Doesn't return total amount?

Join Date: Mar 2011

Posts: 89

shabbaranks is on a distinguished road

Default

SUMIF Doesn't return total amount?

Hi - Im trying to sumif a total as per below

Code:

=SUMIF('MCS Data'!C:C,'Live Data'!B2,MCS_Data[Total Raised])

The total when I manually check is 50 but the SUMIF is coming back as 41 - any ideas why this wouldnt be working?

Thanks

Reply With Quote

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SUMIF with Or	Lluewhyn	Excel	6	02-17-2017 10:48 AM
Another SUMIF	OTPM	Excel	6	06-06-2016 03:00 AM
VBA sumif	Nisio07	Excel Programming	0	02-26-2016 07:53 AM
Force Kiosk published PPT to return to a specific slide after x amount of minutes	jasoomian	PowerPoint	1	07-31-2010 03:09 AM
automatic quantity updation of total amount is restricted.	aligahk06	Excel	0	05-23-2010 08:39 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:17 AM.