=SUMIF(AD19:AD39, A19:A39="XXXXXXXXX", AD19:AD39)
Trying to sum a range of cells in column D that have "XXXXXXX" in the column A as the criteria. "XXXXXX" is a combination of numbers A1&B1&C1.
Keeps returning a dash.
I have columns I want to sum by different XXXXXXX codes.
Any suggestions?
Thanks,
Bookmarks