This does not seem to work
=SUMIF((G417:G419,G422:G425),">0")
Produces #VALUE. In the first argument, I am trying to give a multi-area range.
When using the UI, if you just make a multi-area selection, you will get an error in the formula and it will not even be accepted.
If you hand-edit you can type in the above formula, but it gives #VALUE as the result.
I had thought that if you had a multi-area selection for a function argumet, and enclosed it in (), that it would be treated as a single argument to the function. There are some functions for which this seems to be true. But, for SUMIF it appears to not be true.
So, any way to get a multi-area selection with SUMIF?
Thanks!
=SUMIF((G417:G419,G422:G425),">0")
Produces #VALUE. In the first argument, I am trying to give a multi-area range.
When using the UI, if you just make a multi-area selection, you will get an error in the formula and it will not even be accepted.
If you hand-edit you can type in the above formula, but it gives #VALUE as the result.
I had thought that if you had a multi-area selection for a function argumet, and enclosed it in (), that it would be treated as a single argument to the function. There are some functions for which this seems to be true. But, for SUMIF it appears to not be true.
So, any way to get a multi-area selection with SUMIF?
Thanks!