Selalupug

The whole formula means, to find the number of cells that have a value greater than 0 and then subtract the count of cells with a value greater than 500And then press Enter key to get the result as you need, see screenshot Note In the above formula B2B15 is the cell range that you want to use, >0 and >500 are the criteria you want to count the cells;;18 Excel Vlookup Formul sampling of our mixture of ideas You can practice excel vlookup formula to another sheet to post it wherever you desire or even impress yourself for more inspirations Using Countif Countifs In Google Sheets To Sort Analyze Data Practical Ecommerce Countif function in excel across multiple sheets