Forum Discussion
TMFMinn1234
Mar 17, 2024Copper Contributor
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 date in Column B, total the amount in Column J for the Order ID in Column A
Using SUMIFS, I have the correct value listed in column D
sumifs(j:j,h:h,a2)
THANK YOU
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.
- TMFMinn1234Copper Contributorthank you!!
- PeterBartholomew1Silver Contributor
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.