|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 14th, 2005, 12:07 AM
|
|||
|
|||
no blanks
Can someone please help me to make this formula
=SUMA(SI(S!D4  1000=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
November 14th, 2005, 05:20 AM
|
|||
|
|||
|
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 1000=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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How can I make a Chart data series treat blanks as "Empty" cells | XLADLK | Charts and Charting | 12 | June 9th, 2008 10:53 PM |
| Data Validation and Blanks in List | GoneRural | Worksheet Functions | 1 | October 26th, 2005 05:03 PM |
| Weighed Average of a weiged average when there are blanks | krl - ExcelForums.com | General Discussion | 1 | July 6th, 2005 07:37 PM |
| Weighed average if the adjecent column contains blanks | Kasimir Lehväsl | General Discussion | 2 | July 4th, 2005 10:12 PM |
| Leading and Trailing blanks are lost on import | Dominic Olivastro | General Discussion | 4 | April 28th, 2005 05:50 PM |
Linear Mode
