Microsoft Office Forums - View Single Post - SUMIF Doesn't return total amount?

Thread: SUMIF Doesn't return total amount?

View Single Post

Old

12-11-2020, 03:02 AM

shabbaranks shabbaranks is offline

shabbaranks is offline

shabbaranks uses Windows 7 64bit

Windows 7 64bit shabbaranks uses Office 2007

shabbaranks uses Office 2007

Office 2007

Advanced Beginner

The original poster

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