| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count cells
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count cells
On May 28, 1:21*pm, Question Boy
wrote: 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 Assuming that your Type is in column A and your Delta is in column B =SUM((A2:A9=1)*(B2:B9=0)) This is an Array formula and must be entered with Ctrl+Shift+Enter. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count cells
Hi Q,
Try something like: =SUMPRODUCT(--(Sheet2!A1:A20=1),--(Sheet2!B1:B20=0)) --- Regards. Norman "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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count cells
=SUMPRODUCT(--(A2:A200=1),--(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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count cells
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 |
|
#6
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 | |||
Linear Mode
