Monday, November 19, 2018

One More Excel Beg


SUMIFS sums the first range of cells, if the various range criteria (and there can be many, separated by commas) are met.  In this case, column A contains either a blank cell (for individual mass murders) or a string identifying the decade (e.g., "1830s").  From reading scads of pages about the SUMIFS function, it looks like the formula above should only sum column H if the corresponding column A is blank.  But it does not seem to do that.  Any suggestions?

No comments:

Post a Comment