SUMIF Doesn't return total amount?

Microsoft Office Forums

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

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 11:50 PM.