cfo.com

cfo tagline

Spreadsheets: Wrangling a VLOOKUP

Is it possible to sum all of the matching records from a VLOOKUP formula?

Bill Jelen, CFO.com | US
October 13, 2010

Multiple Sumif formula

For multiple sum if, first you need to open brackets as follows: {=sum(if(....="x",if(...="y"..,range of values,0),0))}. Second, you need to type {} at the beginning and at the end of the formula by pressing Ctrl, Upper Case, Enter keys at the same time while the cursor in on the formula.

Posted by Sameh Kirollos | October 20, 2010 12:44 pm

SUMIFS

As an added wrinkle, if the data spans multiple years, you can use the "sumifs" formula to sum by multiple criteria (Month & Year). This formula allows for up to 127 different range/criteria pairs.

Posted by Kevin Williams | October 14, 2010 03:59 pm

CFO Publishing Corporation 2009. All rights reserved.