Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Won't Work for Me
I'm going absolutely batty trying to figure this out. SUMIF simply will not
work for me when I try anything that requires the criteria portion of the function to be enclosed in double quotes, which completely defeats the purpose of what I'm trying to accomplish. Here's the formula I would LIKE to use: SUMIF('VTI Distributions'!B2:B7,"=D4",'VTI Distributions'!C2:C7) If I try the following, it returns a nonzero value: SUMIF('VTI Distributions'!B2:B7,D4,'VTI Distributions'!C2:C7) Note the only difference is that the criteria portion has been changed to only sum for a certain value. If I change the criteria portion to "=D4", this should return the same value as the above, but it is returning zero. What the heck is going on? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct return value by comparing two criteria..... | Excel Worksheet Functions | |||
Using SUMIF Function with a named cell reference as value in CRITE | Excel Worksheet Functions | |||
Summarizing field quantities for specific records | Excel Worksheet Functions | |||
Need Countif to work like Sumif | Excel Worksheet Functions | |||
Work book formulas | Excel Discussion (Misc queries) |