How write

sumif(A1:10,=ISBLANK(),G1:G10)

??

Sum column G if column A blank

--

Perhaps :
sumif(A1:10,""G1:G10)
Michel


"dpb" a écrit dans le message de groupe de discussion :
...

How write

sumif(A1:10,=ISBLANK(),G1:G10)

??

Sum column G if column A blank

--

Hi,

Am Thu, 3 Sep 2020 21:36:24 -0500 schrieb dpb:

How write

sumif(A1:10,=ISBLANK(),G1:G10)

Sum column G if column A blank

try:

=SUMIF(A:A,"=",G:G)


Regards
Claus B.
--
Windows10
Office 2016

On 9/4/2020 7:51 AM, Péhemme wrote:
Perhaps :
sumif(A1:10,""G1:G10)
Michel

With the missing comman inserted, indeed. Too simple! Thanks.


"dpb"Â* a écrit dans le message de groupe de discussion :
...

How write

sumif(A1:10,=ISBLANK(),G1:G10)

??

Sum column G if column A blank

On 9/4/2020 7:58 AM, Claus Busch wrote:
Hi,

Am Thu, 3 Sep 2020 21:36:24 -0500 schrieb dpb:

How write

sumif(A1:10,=ISBLANK(),G1:G10)

Sum column G if column A blank

try:

=SUMIF(A:A,"=",G:G)


Regards
Claus B.

Ah,so! That also works as did/does

=SUMIF(A:A,"",G:G)

at least all cases so far. Is there any real difference between the two
to prefer one over the other can think/know of?

Thanks, both...
--

Hi,

Am Sat, 5 Sep 2020 07:26:29 -0500 schrieb dpb:

Ah,so! That also works as did/does

=SUMIF(A:A,"",G:G)

at least all cases so far. Is there any real difference between the two
to prefer one over the other can think/know of?

you can use what you like. All three formulae work well.
I prefer the syntax that I use in VBA for the filter:
"<" for all values
"=" for blanks


Regards
Claus B.
--
Windows10
Office 2016