Thread: No Blanks
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default No Blanks
In English...

=sumproduct(--(d4:d1000=g4:g1000),--(d4:d1000<""))



Antonyo wrote:

Can someone please help me to make this formula
=SUMA(SI(S!D4:D1000=S!G4:G1000,1,0))
not to count blanks

Thanks in Advance

Anthony

--

Dave Peterson
Reply With QuoteReply With Quote