You're welcome. Glad to help. Thanks for the feedback.



On Tue, 15 Nov 2005 15:09:04 -0800, "Mir Khan"
wrote:

Hey I got it Thank you I appreciate your help, it was so very necessary for
me...you made my day...i am leaving home satisfied.
Thanks again

"Ron Rosenfeld" wrote:

On Tue, 15 Nov 2005 12:31:04 -0800, "Mir Khan"
wrote:

Hi Experts, I need urgent help Please!!!
I have data of Batches of claims
Column A is date received, Column B is date processed, Column C is time
taken to process (diferrence of Column A and Column B), Column D has number
of claims in the batch, now I need to add and display number of claims that
were processed in 1 - 5 days 6 -10 days 11 - 15 days and 15+ days. is it
possible using If statement???Is it possible in Excel without using macros???
Please Please help me!!!

Assuming named ranges that do not include an entire column:

1-5: =SUMPRODUCT((ElapsTim<=5)*NumClaims)
6-10: =SUMPRODUCT((ElapsTim5)*(ElapsTim<=10)*NumClaims)
11-15: =SUMPRODUCT((ElapsTim10)*(ElapsTim<=15)*NumClaims )
15: =SUMPRODUCT((ElapsTim15)*NumClaims)

ElapsTime: C2:Cn
NumClaims D2:Dn


--ron


--ron