No you can use a cell reference, for instance

=SUMIF(A:A,"="&H1,B:B)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Bongard" wrote in message
oups.com...
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!