Your question is not clear, at least to me.

I am not seeing where the variable data is and hat is repeated, so what
needs to be counted/summed?

--
__________________________________
HTH

Bob

"Sue" wrote in message
...
Question:
Category Processed (Yes) Not Processed(No)
Count Sum(Amt) Count Sum(Amt)
1 - 25
26 - 50
51 - 100
101 - 250
Total

Data has two columns which are Amount and Status(Yes/No). Can someone help
me with the formulae to count the number of coumns which fall in each
Category and also sum of the amounts in those categories?
--
Sue