View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] timmie7004@yahoo.co.uk is offline
external usenet poster
 
Posts: 8
Default COUNT based on 2 criteria

Just tried that, answer = 7, but should be 2

If I have 10 columns of data and the range name 'Purchases' is in
Column F, how would the formula count the number of receipts, for
Store 123 and Inventory_No in I6, or am I missing something?