Katamejgr

G glerwell Wellknown Member Joined Messages 1,080 We have a great community of people providing Excel help here, but the hosting costs are enormous You can help keep this site running by allowing ads on MrExcelcom You can use the COUNTIFS function to count not blank cells with a given criteria in excel Summary Not Empty Cells with COUNTIFS Assuming you have a dataset in range A1C6, and you want to create a formula which can count nonblank cells in column C Non blank means something has not been enter I have a data set in which I want to use Countifs and Sumifs to help summarise data All this data is held on the sheet "Tank" (just so you know why that name is there later) For the Countifs I have three formulas, each having a criteria of, blank, not blank and all respectively How To Handle Countif With Multiple Criteria In Excel Magoosh Excel Blog Excel countifs criteria not blank