ahh. never mind what I have. I asume you want it to have a rolling
calculation. that's a summproduct, and I don't know the formula off the top
of my head...

"Sean Timmons" wrote:

=if(A2=criteria,sumif(),whatever you want it to show if doesn't fit criteria)

"Sandy@law" wrote:

I need a formula that will look at column A and if meets the criteria then do
a SumIf based on two other columns with another criteria.