Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Blanks non blanks in filter | Excel Discussion (Misc queries) | |||
Blanks non blanks in filter | Excel Discussion (Misc queries) | |||
Sumproduct copying blanks or how to insert zero into blanks | Excel Worksheet Functions | |||
copy range of cells with blanks then paste without blanks | Excel Worksheet Functions | |||
Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) |