Tag Archives: SUMIF

Conditional Sum On #N/A Text Values

Today’s post is inspired by a question which came up over at the MrExcel.com forums. Here’s my spreadsheet: It’s pretty simple. In cells A1:A2 I have the formula =”#N/A” and in cells A3:A4 I have the formula =NA(). Whilst the outputs … Continue reading

Posted in Microsoft Excel | Tagged , , | 1 Comment

Calculate The Absolute Sum in Excel

A colleague of mine asked me today how to go about using MS Excel formulas to calculate the sum of absolute values from a given dataset. This question crops up quite often on the forums so I thought I’d put together a quick blog … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , , , | 2 Comments

SUMIF From VBA

There are three ways we can be involved with SUMIF() when we are using VBA. The Range.Formula(), Range.FormulaR1C1() and Range.FormulaArray() Properties This is a straightforward process. To enter a formula containing SUMIF() we use the Range.Formula or Range.FormulaR1C1 properties: If … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , , , , , | Leave a comment

SUMIF Formulas

1 Introduction At some point in your Excel work you are almost certainly going to want to conditionally sum a range of cells. If you find yourself in that situation then SUMIF() is probably going to be what you need: … Continue reading

Posted in Microsoft Excel | Tagged , , , , , , , , , , , , , , , , , , , | 12 Comments