Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Finally gave up and have to ask the question..
I have a simple spreadsheet with 5 columns, column B is places, column D is a statement of "Done" or "NOT Done". All I want to do is count the number of records there are per place that are NOT Done. eg column B includes a place called Central London, I want to count the number of records if B= "Central London" and D= "NOT Done". Any assistance would be gratefully received. Many thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
COUNTIF & AND Functions | Excel Worksheet Functions | |||
COUNTIF & AND FUNCTIONS | Excel Discussion (Misc queries) | |||
Using COUNTIF and AND functions together | Excel Worksheet Functions | |||
countif functions | Excel Worksheet Functions | |||
CountIf functions | Excel Discussion (Misc queries) |