View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
meast meast is offline
external usenet poster
 
Posts: 2
Default Count if criteria extracts from 2 cells both with formulas

I am looking to count ranges from columns A and B where if cells within both
are true then formulated cell = total

Therefore; if there are 5 cells in row A (contains vlookup) that = 12 and
only 3 cells in column B (contains if formula) that = "On Time" then my
formulated cell would equal 3 because only 3 sells match the criteria within
the range of both columns.