#1   Report Post  
Old September 4th 20, 03:36 AM posted to microsoft.public.excel.programming
dpb dpb is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2018
Posts: 91
Default Syntax?

How write

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

??

Sum column G if column A blank

--

  #2   Report Post  
Old September 4th 20, 01:51 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2020
Posts: 2
Default Syntax?

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

--

  #3   Report Post  
Old September 4th 20, 01:58 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,802
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
  #4   Report Post  
Old September 5th 20, 01:23 PM posted to microsoft.public.excel.programming
dpb dpb is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2018
Posts: 91
Default Syntax?

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


  #5   Report Post  
Old September 5th 20, 01:26 PM posted to microsoft.public.excel.programming
dpb dpb is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2018
Posts: 91
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...
--




  #6   Report Post  
Old September 5th 20, 01:34 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,802
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why is Access VBA syntax different from Excel syntax? cr113 Excel Programming 2 December 2nd 09 01:42 AM
vba syntax Derrick Excel Discussion (Misc queries) 11 August 5th 09 08:37 PM
VB Syntax dhstein Excel Discussion (Misc queries) 6 November 8th 08 10:13 PM
SQL syntax Jeffiec Excel Programming 1 June 14th 05 05:47 PM
syntax Don[_13_] Excel Programming 2 November 16th 03 04:30 AM


All times are GMT +1. The time now is 02:56 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017