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.

Count if criteria extracts from 2 cells both with formulas
 

=sumproduct(--(range1=12),--(range2="on time"))
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"meast" wrote:

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.

Count if criteria extracts from 2 cells both with formulas
 

Thank you M Kan for such a speady response. However, for some reason I gon
back #N/A. The exact formula used is =SUMPRODUCT(--('Aug
''08'!C13:C476=12),--('Aug ''08'!L13:L476="On Time")) . Did I miss something?

"M Kan" wrote:

=sumproduct(--(range1=12),--(range2="on time"))
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"meast" wrote:

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.