RC Notation and additional criteria

[mkc80]

I need to add a condition to the already existing criteria:



The existing Criteria is: Count the rows where the value in a column is either "Yes" or "MayBe",
AND now I would like to add another condition:Check if in the same 'Report' tab, but a different column, the value is "Europe"

Essentially, I would like to count how many rows in Column 5 have the answer "Yes" or "MayBe" WHEN the Continent is "Europe"

Range("B2").Select
ActiveCell.FormulaR1C1 = _
"=SUM(COUNTIF('Report'!R[1]C[5]:R[2498]C[5],""Yes""),COUNTIF('Report'!R[1]C[5]:R[2498]C[5],""MayBe""))"

Please Advise.

[JoeM]

Your question looks like an Excel question (references to rows, columns, and Excel formulas), but you posted it in an Access forum.
Did you mean to do this?
If you are trying to do this to Excel data, but through Access, I would link the Excel table into Access and then use Access query functionality to apply your criteria.

[June7]

If you must use Excel function, look at the COUNTIFS function.
= SUM(COUNTIFS(B2:B6,"Yes",C2:C6,"Europe"),COUNTIFS( B2:B6,"Maybe",C2:C6,"Europe"))

[mkc80]

@June 7: Thank you so much!