So, here's the puzzle:
I have 2 set of conditions i want to see met, and count the times both of them are true.
When I write =countifs(A1:A20="Pizza",True,B1:B20="Pepperonni",True), Excel doesn't even allow me to check results. Instead, it simply demands that I insert ' in the beginning of the formula, because it doesn't recognize what I wrote as a formula.
If however I replace the values in A1:A20 and B1:B20 with trues and falses, the formula works. In other words, when I write =countifs(A1:A20;True;B1:B20;True) the value returned is correct.
I want these conditions to be embedded in the formula and not in cells, because I want to do multiple variations of conditions and this simply isn't practical.
Anyone out there as an idea of what might be causing excel to freak when I embed the conditions in the countifs?
Thanks a million in advance.
Bookmarks