=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.