filtering correct?

[usmanmh]

does anyone know if this works correctly as i need to calculate a high amount of data

i have converted seconds into =E2/24/60/60 which is the time

and cost into £0.41


i am now filtering the data to calcuate certain destinations
so selecting the filters to show certain data then carrying out a =sum(flitered fields)


thanks for any help

 

[Andrew Poulsom]

Use the SUBTOTAL function to sum the visible records in a filtered list:

http://support.microsoft.com/kb/244789

 

[usmanmh]

to calculate a list of filtered fields you would function count 2 ?