Forum Discussion
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.
8 Replies
You were such an awesome help with my previous problem - maybe you can help with this one? I have an excel workbook with tabs at bottom. 1st sheet is master tab - every person will get put on this tab. Column B is a drop down, depending on the type of client it is. I would like that information to them feed over to the appropriate worksheet at the bottom based on the answer in column b. Note - column b is a drop down. Spreadsheet is attached.
See the attached workbook.
- That worked! Thanks so much..
