Forum Discussion
SUMIFS only if a date is entered
Hello! I would like help to create a formula in column C that checks column B for a date. If there is no date listed, then nothing else is calculated, or return a value of 'not paid' If there is a...
Different practices in that I avoid relative references and entire column formulas.
= IF(datePaid, SUMIFS(total, orderID, transaction), "")It is a single 365 formula that spills to the entire table.