What do you mean by formulated cells?

Something like

=SUMIFS(F2:F20,A2:A20,""&A1,B2:B20,"<"&B1)

HTH

Bob

"Kristin" wrote in message
...
Can SUMIFS be used with formulated cells? or does that formula only work
with
straight values in the cell?