Next, I tried using an asterisk wildcard as the criterion, if C was empty. That created totals in the rows with blank cells, but it only added up the other blanks. It’s interesting that SUMIFS returns a zero if there is an empty cell in column C.įor my first solution, I tried using an empty string as the criterion, if C was empty. How can we change the formula, so it ignores the criterion for C, if the current row has an empty cell in column C?įirst, I set up a sample sheet, where I could do a bit of experimenting, and entered the original formula in column E See more SUMIFS examples on the Sum Cells page of my Contextures website.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |