Forum Discussion
How to use COUNTIF only if certain conditions are met
- Aug 16, 2018
Hia,
If I understand the question then I think the attached solves it.
The extra formula is an array so needs to be entered with ctrl+shift+enter.
Thank you Philip. Not homework, but real work. I made it work with the formula. Your pivot table just added all the classes x or not. There is one more item. I thought that I could figure it out with the information you gave me, but no. There is another column - Times taught. I need to multiply that number with the Class length column. Can I do this on the fly or do I need to have a hidden column that does this and pick up the number from that column? I've attached the worksheet with the new column.
Hia,
If I understand the question then I think the attached solves it.
The extra formula is an array so needs to be entered with ctrl+shift+enter.