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...
In C2:
=IF(B2="", "", SUMIFS($J$3:$J$11, $H$3:$H$11, A2)
or
=IF(B2="", "Not Paid", SUMIFS($J$3:$J$11, $H$3:$H$11, A2)
Fill down.
thank you!!
