Syntax?
How write
sumif(A1:10,=ISBLANK(),G1:G10) ?? Sum column G if column A blank -- |
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 -- |
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 |
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 |
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... -- |
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 |
All times are GMT +1. The time now is 06:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com