Monday, November 19, 2018

One More Excel Beg

=SUMIFS(massmurder!$H$2:$H$300,massmurder!A2:A300,"=")

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: