Got it, thanks for your help Don. My problem was that I was trying to
use a cell reference for the criteria and it only allows you to use a
number, text or an expression. I had to manually type the criteria then
for every formula, but this was a quick workaround for conditionally
summing 3000 rows.

Thanks!