Thread: Syntax?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Syntax?
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
Reply With QuoteReply With Quote