Forum Discussion
Need help with a formula in excel
Greetings, I need help writing a formula. Attached is a screen shot of my data in excel. What I am trying to accomplish is to have excel return the number of times a specific code occurs under ea...
use the countifs formula, you can enter multiple criterias your first criteria is your column on the left part, then the second criteria is your column heading. use absolute rows for your criteria range and your second criteria.
countif works just for single criterias countifs is best used for multiple-you need not enter complex ifs or array formulas
next time include a file that can be edited for clarificatory details