Comparing a range against a range

[Bob Phillips]

I want to add the values in Range E7:E507 as long as they have second digit "1" and Cell N13 is empty, Otherwise sum everything in range E7:E507

Thanks

Did you try what I suggested?