count if formula

Hello, I want to count data with criteria (N/A), if i want count PN 1 (N/A). what is wrong with this formula ? =IF(G3:G19="PN 1";COUNTIF(H3:H19;"N/A");0) Thanks FGH123PN 1N/A4PN 1N/A5PN 116PN 127PN 138PN 1N/A9PN 1N/A10PN 1411PN 1N/A12PN 2513PN 2614PN 2715PN 2N/A16PN 2N/A17PN 2N/A18PN 2019PN 2120

'This method Saves each of the worksheets of current 'Excel file as individual PDF File using Excel VBA Sub SaveEachSheetAsPDFFileED() Dim wsA As Worksheet Dim wbA As Workbook Dim WS_Count As Long Dim strFile, myfile As String Set wbA = ActiveWorkbook...

I am using the formula B1=COUNTIF(INDIRECT(A1&"!E:E"),"<>")-1 But when there is space in between in Column A then I am getting error as #REF!, for example when I have cell value as "REDORANGE" its showing value but when I am using "RED ORANGE" its showing #REF! and my sheet name is "RED...

hi, i have a table called mytransaction. in this table there is a column, R, to indicate the user has checked on the transaction. there is also another collumn call source where they select which account is involve in that transaction. so now in one of the cell i would like to count how many...

I have an excel where in D column Same name are appearing multiple times. They are already grouped I just need to provide unique_id code (1, 2, 3...) for each group as shown in below example in column E: Col A Col B Col C Col D Col E...