I have this table of data with column headers as follows..."School Code", "ISBN", "Cost",etc...Is there a formula or combination that will (1) extract all the ISBN's for a particular "School Code", then (2)Multiply each extracted record by its associated cost? I am trying to avoid pivot tables...
I am attempting to retrieve data based on "service dates" prior to July 2010 and dates in July 2010 or later. Results for each of these periods will be placed in cells A1 &B1. However, because the fiscal year runs from July 10-June 11, i can foresee a problem when January 11 comes around as data...