I have a large spreadsheet with a lot of data in it. It would be really helpful if I could use a formula to tell me how many items there are in a filtered search, so that I know the size of the population sample I am looking at. If I choose a filter option in column A and one in column C, how can I tell how many results fulfil these criteria without just counting the rows?!
-- View our outstanding ISI & OFSTED reports: www.monktoncombeschool.com Follow us on twitter@Monkton Open Days: 7th March 2015, 9th May 2015 DISCLAIMER: The information contained in this e-mail and any files transmitted with it is confidential and intended for the addressee only. If you have received this e-mail in error please accept our apologies and notify the originator. Any disclosure, copying, distribution or any other use of this communication is strictly prohibited and may be unlawful. We reserve the right to monitor and intercept communications for lawful business purposes. Monkton Combe School Ltd Company No: 3228456, Charity No 1057185, Monkton Combe School, Bath BA2 7HG -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
