Not sure which function...

[Guest]

Hello,

I have a list of various claim numbers, dates checks were issued for
(service dates), and the span for between service dates. For each check that
was issued there is a listing for that claim number. For some claims there
can be quite a few entries.

I need to consolidate each group of claim numbers into an entry that totals
the span. Please help! Thanks!

 

[Guest]

Anyone?

 

[Dave R.]

If i understand, you want to total all the $ entries for one claim..
Sounds like a "SUMIF" might work. See if this would do it;
get a list of all unique claim numbers. you can do this with
data>filter>advanced filter select "unique records only"

Then select the filtered range, and copy and paste it somewhere, say into A2
(A1 being some label for claim #).
With your new list in A2:A100 (for example), and your old claim numbers in
say D2500 with the $ value in E1:E500, use a formula like this in B2;

=SUMIF($D$2:$D$500,A2,$E$2:$E$500)

 

[Dave R.]

Oh yeah, you can go to "data>filter>show all" anytime after you've pasted
the unique list.

 

[Guest]

have you tried a pivot table?

also, your question is a little vague so not sure if a pivot table wil suffice