Count If Function
I have a spreadsheet and all the cells have formulas that are feeding info from another spreadsheet. Until data is entered on the master, the cell on the current spreadsheet is empty (except for the formula). I want a total at the bottom of the column that tells me how many “jobs” are on the spreadsheet. if I use the countif(a1:a300″*”), it is returning 300 because they all contain a formula. I only want to total the ones that actually returned data.
I have a spreadsheet and all the cells have formulas that are feeding info from another spreadsheet. Until data is entered on the master, the cell on the current spreadsheet is empty (except for the formula). I want a total at the bottom of the column that tells me how many “jobs” are on the spreadsheet. if I use the countif(a1:a300″*”), it is returning 300 because they all contain a formula. I only want to total the ones that actually returned data. Read More