Forum Discussion
What is wrong with this formula?
excelisfunny wrote: ``I suppose when you start a question off with "why doesn't this work" without explaining what I'm trying to do...``
Yup. GIGO!
-----
excelisfunny wrote: ``I need the total count of [...] those have to be over 1 to count, PLUS the total count of four other cells that have to be over 0 [....] If there is another way to do it I'm all ears.``
For that purpose, your COUNTIF(...)+COUNTIF(...) expression is exactly how I would do it.
But I would eschew the outer parentheses. IOW, I would write =COUNTIF(...)+COUNTIF(...).
I never said nor implied otherwise. As you noted, I could not comment on it since I did not know your intent.
I have 6 cells columns in a row that I'm tracking the count of. I need the total count of two of the cells, and those have to be over 1 to count, PLUS the total count of four other cells that have to be over 0. So they won't be the same number of columns. I had assumed COUNTIFS was the equation I could use but it turns out I was wrong and that isn't the appropriate use of that equation. However, adding two different COUNTIF equations did the trick, as mentioned in my workaround. If there is another way to do it I'm all ears.
excelisfunny wrote: ``I suppose when you start a question off with "why doesn't this work" without explaining what I'm trying to do...``
Yup. GIGO!
-----
excelisfunny wrote: ``I need the total count of [...] those have to be over 1 to count, PLUS the total count of four other cells that have to be over 0 [....] If there is another way to do it I'm all ears.``
For that purpose, your COUNTIF(...)+COUNTIF(...) expression is exactly how I would do it.
But I would eschew the outer parentheses. IOW, I would write =COUNTIF(...)+COUNTIF(...).
I never said nor implied otherwise. As you noted, I could not comment on it since I did not know your intent.
- Thanks! Happy to learn I've got a responsive helpful community to nerd out on Excel with... 🙂