=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:
Post a Comment