Returning Rows from Search in Excel -

i have hard time explaining things apologize in advance if things, or everything, doesn't make sense. okay, here's dilemma. have spreadsheet couple columns (shown here separated "|"):

time | user | bytes sent | server id

the data in sheet collected @ irregular intervals. script gets data samples cumulative amount of bytes sent "user" "server id" , puts in time sampled, goes next row.

the values sorted according time. need calculate average bitrate based on time sample received , number of bytes sent. difficult part calculation should done on rows match "id" , "server" user searches for. on top of that, has automated because i'm making tech support people who, me, have limited knowledge in excel.

what thinking doing searching through sheet , putting rows have matches different sheet, simple calculation on sheet average bitrate. question is, how extract rows?

ok here how in excel 2007/2010.

i did in table way (you can change table references cells , way) need convert data table , named table "data".

the cell '4' in named "server_cell" , cell 'd' in named "user_cell"

i entered formula in cell see '10':

=sumproduct((--data[server]=server_cell)*(data[user]=user_cell)*(data[@bytes]/data[time]))

now when if change '4' '1' , 'd' 'p' 10 changes 0 because wasn't found.