Hi there,
I'm trying to put together two countifs in a division formula and am running into issues.(the percentage doesn't seem right) I have attached the file. Formula is in F4 of "test" worksheet.
Basically, I want to add both the Q1 and Q2 data together. So the rule is...... (Yes of Q1+ Yes of Q2)/(all Q1 + all Q2)Please Login or Register to view this content.
Can I still use the countifs in this case? or it should be something else that I should be looking at?
THanks
Bookmarks