Thread: Syntax?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
dpb dpb is offline
external usenet poster
  
Posts: 109
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


Reply With QuoteReply With Quote