View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default multiple criterion to give sum

Sorry, just detected my typo error on "Virginia" in lines such as:
Col G contains the 6 destinations, eg: Virgina, Kentucky, etc
List the 6 destinations within say: E1:E6 (Virgina, Kentucky, etc)


It's crucial to ensure that there's consistency between the 6 destination
names entered in E1:E6, and the destination names found within col G in Daily
Log.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---