summarizing data without a pivot table?

Have you try Advanced Filter?

I have never used advanced filters but I think I need it to be an actuall function if possible. I don't want them to have to do anything other than enter a limited amount of data on one tab. Then on the other it will automaticaly be summarized on the report.

OK I have read up on the advaced filter and I can not get it to work. What would the criteria be? At first I thought I could use it for everything but soon realized I don't think I can.

Let me give a bit more detail on what I am trying to do. We have an expense report that employees turn in. It has travel cost, entertainment cost, hotels, ect across the top along with a column for location to be charged to. it is possible for one person to have expenses charged to several locations several different days. rather than sum them up here manualy for every employee we are trying to create a worksheet where the employee enters all of their expenses and then on an expense sheet it is summed up by location by type. If I can get the list of locations in to the report I think I can run a sumproduct from there and get the rest.

Originally Posted by txbullets

OK I have read up on the advaced filter and I can not get it to work. What would the criteria be? At first I thought I could use it for everything but soon realized I don't think I can.

Let me give a bit more detail on what I am trying to do. We have an expense report that employees turn in. It has travel cost, entertainment cost, hotels, ect across the top along with a column for location to be charged to. it is possible for one person to have expenses charged to several locations several different days. rather than sum them up here manualy for every employee we are trying to create a worksheet where the employee enters all of their expenses and then on an expense sheet it is summed up by location by type. If I can get the list of locations in to the report I think I can run a sumproduct from there and get the rest.

Rng is a defined name range

=IF(ISERR(SMALL(IF(MATCH(Rng,Rng,0)=ROW(INDIRECT("1:"&ROWS(Rng))),MATCH(Rng,Rng,0)),ROWS($1:1))),"",INDEX(Rng,SMALL(IF(MATCH(Rng,Rng,0)=ROW(INDIRECT("1:"&ROWS(Rng))),MATCH(Rng,Rng,0)),ROWS($1:1))))

ctrl+shift+enter, not just enter
copy down as far as needed

that worked great thank you