Count if criteria extracts from 2 cells both with formulas

M

meast

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

meast

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Cells with Multiple Range Criteria (Excel 2003) 7
Excel Use COUNTIF across a range of cells with formulas 0
Count Non-Blank Cells in Column If a Reference Criteria Met. 5
VBA set thick borders around non empty cells in range 0
Finding Text within an Array 2
CountIf with 2 criteria possible? 1
comparing 2 sheets with a range 2
MAX AVERAGE MIN with additional criteria, ignoring blank cells 6

Top