| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
criteria for two different cells in a count if function
I have one column where I want to count if it equals a certain value, I need
to sum all the rols that have that value that are of a certain date that would be specified in another column, how do I phrase a countif column that would perform such function? For example Countif column B=0 and column H=10/1/08.... Thank you for your help, the other items listed were close but nothing that mentioned this specifically. -- Judy Rose Cohen |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
criteria for two different cells in a count if function
Try this:
=SUMPRODUCT(--(B1:B10<""),--(B1:B10=0),--(H1:H10=DATE(2008,10,1))) -- Biff Microsoft Excel MVP "Judy Rose" wrote in message ... I have one column where I want to count if it equals a certain value, I need to sum all the rols that have that value that are of a certain date that would be specified in another column, how do I phrase a countif column that would perform such function? For example Countif column B=0 and column H=10/1/08.... Thank you for your help, the other items listed were close but nothing that mentioned this specifically. -- Judy Rose Cohen |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
criteria for two different cells in a count if function
=SUMPRODUCT(--(ISNUMBER(B2:B100)),--(B2:B100=0),--(H2:H100=DATE(2008,10,1)))
countif won't work given you have multiple criteria in multiple columns Excel 2007 has a function called COUNTIFS that will work But the above will work -- Regards, Peo Sjoblom "Judy Rose" wrote in message ... I have one column where I want to count if it equals a certain value, I need to sum all the rols that have that value that are of a certain date that would be specified in another column, how do I phrase a countif column that would perform such function? For example Countif column B=0 and column H=10/1/08.... Thank you for your help, the other items listed were close but nothing that mentioned this specifically. -- Judy Rose Cohen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a function to count cells based on multiple criteria | Excel Worksheet Functions | |||
| Mutliple Criteria Count function | Excel Worksheet Functions | |||
| Count no of cells containing data for more than one criteria | Excel Worksheet Functions | |||
| How can I reference a cell as the criteria in a count if function. | Excel Discussion (Misc queries) | |||
| HOW DO I USE THE COUNT IF FUNCTION FOR 2 CRITERIA | Excel Worksheet Functions | |||
Linear Mode
