#1
|
|||
|
|||
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]) Thanks |
#2
|
|||
|
|||
Not with out seeing the worksheet - can you upload?
|
#3
|
|||
|
|||
Some values in range are really texts.
This may happen when you enter data into cells formatted as text, and change format afterwards. Or when you copy data from elsewhere, and use Paste instead PasteSpecial -Values (this may change cell format to text for various reasons). Simply formatting the range with such values displays them like they were numbers, but really they remain texts. To make the new format applied, you have to edit every such cell. To check this, you remove alignment from range and enter a suspect cell in edit mode (double-click or select cell and press F2). When the value is numeric, it will be right aligned, when text, then left aligned. When there is lot of data, it's easier simply correct issue. Format your range as General, or Numeric. Enter 1 into some unused cell (formatted as General), and copy the cell. Select your range, and then PasteSpecial - Multiply. This updates all cells in selected range leaving all values same. Another issue is, that you use 2 different ranges from sheet 'MCS Data', C:C and Table column MCS_Data[Total Raised]. MS recommends to have all ranges used with SUMIF() or SUMIFS() of same dimension. Ignoring this may affect the result. |
#4
|
|||
|
|||
Hi
Thanks for your replies - its strange as I re-copied the data and now its working. As I said I knew my formula was correct as I used it in a test - thanks guys! |
Thread Tools | |
Display Modes | |
|
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 |