| Home > Forum Home > Analyzing Corporate Financial Data > Countif with two criteria > Adding COUNTIF statements | Share |
Adding COUNTIF statements
Excel Help for Adding Countif Statements in Analyzing Corporate Financial Data
| Forum Topic | Login |
Adding Countif Statements | Rate this: (3/5 from 1 vote) |
 | From the situation, it appears that you want to count cells in the range that have either 1 or are blank. If this is the case, you can simple add multiple COUNTIF statements to return the total. e.g.: =COUNTIF($G$2:$G$17,1)+COUNTIF($G$2:$G$17,"") | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Adding COUNTIF statements in the Excel Business Solutions Directory |