no blanks

A

Antonyo

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
 
J

Jezebel

Insert a column (eg H). Insert a formula: =(D4=G4) and copy downwards. That
will show TRUE if the values are the same and FALSE otherwise. Then use
=Countif(H4:H1000, "TRUE")
 
A

Antonyo

This will take a lot of room in my program
and will slow down it
This formula works fine only I need not to count blanks
if you have some other alternative to star thanking you
wil be great
Anthony
 
H

Héctor Miguel

hi, Antonyo !
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 [...]
Click to expand...

op1: =sumaproducto(--(s!d4:d100=s!g4:g100))
op2: =sumaproducto(1*(s!d4:d100=s!g4:g100))

hth,
hector.

p.s. if you use an english version of excel, change [the function] sumaproducto to sumproduct
multi-posting is not a good idea, if you think it's needed, do a cross-posting
 
A

Antonyo

Ops
Besides it will still count blanks






Jezebel said:
Insert a column (eg H). Insert a formula: =(D4=G4) and copy downwards. That
will show TRUE if the values are the same and FALSE otherwise. Then use
=Countif(H4:H1000, "TRUE")
Click to expand...
 
H

Héctor Miguel

skip blanks...
op3: =sumaproducto((s!d4:d100>0)*(s!d4:d100=s!g4:g100))

regards,
hector.
 
Top