Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 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 |
#2
|
|||
|
|||
no blanks
suppose data in a1 to a10 and b1 to b10 with some blanks in column A
try this fomula in an empty cell =SUMPRODUCT((A1:A10<"")*(A1:A10=B1:B10)) "Antonyo" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation and Blanks in List | Excel Worksheet Functions | |||
Weighed Average of a weiged average when there are blanks | Excel Discussion (Misc queries) | |||
Weighed average if the adjecent column contains blanks | Excel Discussion (Misc queries) | |||
linking files with blanks | Excel Discussion (Misc queries) | |||
Filling in blanks. | Excel Worksheet Functions |