Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Syntax?
How write
sumif(A1:10,=ISBLANK(),G1:G10) ?? Sum column G if column A blank -- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why is Access VBA syntax different from Excel syntax? | Excel Programming | |||
vba syntax | Excel Discussion (Misc queries) | |||
VB Syntax | Excel Discussion (Misc queries) | |||
SQL syntax | Excel Programming | |||
syntax | Excel Programming |