If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Countif Formula
A B
1 112233 Expired 2 113344 Valid 3 116655 Valid 4 117799 N/A This Formula is to calculate the number of employee in the column. =COUNTIF(A1:A4,"*"). Can I make it =COUNTIF(A1:A4,"*")- N/A. I mean I want it the formula to calculat the number of employee but if the Column B has the work N/A. include it in the calculation. |
#2
|
|||
|
|||
Countif Formula
Try
=COUNTA(A1:A10)-COUNTIF(B1:B10,"N/A") 'If you want to count only if there is a numeric value in colA then you may try =SUMPRODUCT((ISNUMBER(A1:A100))*(B1:B100"N/A")) -- Jacob (MVP - Excel) "Khalid A. Al-Otaibi" wrote: A B 1 112233 Expired 2 113344 Valid 3 116655 Valid 4 117799 N/A This Formula is to calculate the number of employee in the column. =COUNTIF(A1:A4,"*"). Can I make it =COUNTIF(A1:A4,"*")- N/A. I mean I want it the formula to calculat the number of employee but if the Column B has the work N/A. include it in the calculation. |
Thread Tools | |
Display Modes | |
|
|