Thread: Syntax?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
dpb dpb is offline
external usenet poster
 
Posts: 109
Default Syntax?

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...
--