| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count cells
Thank you all so very much!
"Bob Phillips" wrote: Should have been =SUMPRODUCT(--(Sheet2!A2:A200=1),--(Sheet2!B2:B200=0)) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Question Boy" wrote in message ... I have 2 sheets. Sheet 2, which has a data table and Sheet 1, which is to tabulate the data. Sheet 2 has 2 columns, Type and Delta. How can I count the number of entry in Sheet 2 that are of Type =1 and whose Delta = 0? Thank you, QB |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to count#cells w/= value in other column and not count blank c | Excel Worksheet Functions | |||
| count cells, then reset count when value in another cell changes | Excel Worksheet Functions | |||
| Count Empty Cells in Range After Cells with Data | Excel Programming | |||
| HOW TO FORMATE CELLS TO COUNT CELLS WITH A FILL COLOR? | New Users to Excel | |||
| Using the COUNT funciton to count cells with values | Excel Programming | |||
Hybrid Mode
