No Blanks
 

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

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

No Blanks
 

Mr. Peterson Thanks for you replay

=SUMA(SI(S!D4:D1000=S!G4:G1000,1,0))

This formula works Good Only it's also count empty cells
I need to count duplicate numbers that are in the same row
Example:
D4 G4
300.00 300.00
Count like one




"Dave Peterson" escribió en el mensaje
...
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

No Blanks
 

Select the cell that should have the formula.
Then hit alt-f11 (to get to the VBE)
then hit ctrl-g (to see the immediate window)

Type this and hit enter:
activecell.formula = "=sumproduct(--(d4:d1000=g4:g1000),--(d4:d1000<""""))"

Then swap back to excel and look at that formula. (It'll be translated for
you.)

Did it work?

Antonyo wrote:

Mr. Peterson Thanks for you replay

=SUMA(SI(S!D4:D1000=S!G4:G1000,1,0))

This formula works Good Only it's also count empty cells
I need to count duplicate numbers that are in the same row
Example:
D4 G4
300.00 300.00
Count like one

"Dave Peterson" escribió en el mensaje
...
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

--

Dave Peterson

No Blanks
 

Mr. Peterson

It did not work



"Dave Peterson" escribió en el mensaje
...
Select the cell that should have the formula.
Then hit alt-f11 (to get to the VBE)
then hit ctrl-g (to see the immediate window)

Type this and hit enter:
activecell.formula =
"=sumproduct(--(d4:d1000=g4:g1000),--(d4:d1000<""""))"

Then swap back to excel and look at that formula. (It'll be translated
for
you.)

Did it work?

Antonyo wrote:

Mr. Peterson Thanks for you replay

=SUMA(SI(S!D4:D1000=S!G4:G1000,1,0))

This formula works Good Only it's also count empty cells
I need to count duplicate numbers that are in the same row
Example:
D4 G4
300.00 300.00
Count like one

"Dave Peterson" escribió en el mensaje
...
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

--

Dave Peterson

No Blanks
 

Sorry,


Antonyo wrote:

Mr. Peterson

It did not work

"Dave Peterson" escribió en el mensaje
...
Select the cell that should have the formula.
Then hit alt-f11 (to get to the VBE)
then hit ctrl-g (to see the immediate window)

Type this and hit enter:
activecell.formula =
"=sumproduct(--(d4:d1000=g4:g1000),--(d4:d1000<""""))"

Then swap back to excel and look at that formula. (It'll be translated
for
you.)

Did it work?

Antonyo wrote:

Mr. Peterson Thanks for you replay

=SUMA(SI(S!D4:D1000=S!G4:G1000,1,0))

This formula works Good Only it's also count empty cells
I need to count duplicate numbers that are in the same row
Example:
D4 G4
300.00 300.00
Count like one

"Dave Peterson" escribió en el mensaje
...
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

--

Dave Peterson

--

Dave Peterson