Help with Excel formula, COUNTIFS
Budget: $10 – $30 USD
Hi,
I have a range spanning between several columns and rows in which I want to count the number of occurrences of certain words. The trick is that I I only want to count the number of x in the rang, if the value is z on the same row but in a column outside the rang.
Guessing its easy of you know how. Please see example.
/Joakim
I have a range spanning between several columns and rows in which I want to count the number of occurrences of certain words. The trick is that I I only want to count the number of x in the rang, if the value is z on the same row but in a column outside the rang.
Guessing its easy of you know how. Please see example.
/Joakim