no blanks "Antonyo" <AntonioAtala[ at ]hotmail.com> 14.11.2005 00:08:23 Can someone please help me to make this formula =SUMA(SI(S!D4:D1000=S!G4:G1000,1,0)) not to count blanks i need to count nubers that are the same in the same row Example: D4 G4 300.00 300.00 Count like one Thanks in Advance

Re: no blanks "Jezebel" <warcrimes[ at ]whitehouse.gov> 14.11.2005 06:45:14 Please don't repeat your posting. This is fifth time you've posted the question; and it was long-ago answered elsewhere. "Antonyo" <AntonioAtala[ at ]hotmail.com> wrote in message news:ebNBM$K6FHA.252[ at ]TK2MSFTNGP15.phx.gbl... [Quoted Text] > Can someone please help me to make this formula > =SUMA(SI(S!D4:D1000=S!G4:G1000,1,0)) > not to count blanks > i need to count nubers that are the same in the same row > Example: > D4 G4 > 300.00 300.00 > Count like one > > Thanks in Advance > >