Thread: Syntax?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Syntax?

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