#### Joe Galvan

##### Board Regular

- Joined
- Jun 24, 2008

- Messages
- 152

I am unable to download that Spreadsheet Genie, so I will do my best...

This is what I have for the formula so far...

Sum(if(Claim Detail!$O$9:$O$11000>=$D$1,if(Claim Detail!$O$9:$O$11000<=$E$1,if(Claim Detail!$M$9:$M$11000=$B$42

The last if is what I am having trouble with.... I need the last "IF" to compare a list of values to a row on the Claim Detail page...

Values Example (There is a list of 20 different values)

A

B

C

D

E

So the last "IF" statment in the above formula needs to match column K on the Claim Detail tab to any one of the Values... So after the previous "IF's" are satisfied, the last "IF" could match A or B or C etc...and then finally sum column BQ on the Claim Detail tab...

Make Sense???

Thank you,

JOE