| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNT IF FUNCTION
Hello, I am trying to countif a range of cells if they meet and certain
criteria and if another range meets a certain criteria. I would like to count the # of times the score = 0 when the date = 1. I tried this function =if(b1:b4=1,countif(d1:d4,0),0) however that returned "0". Any ideas? UM DATE CLAIM# SCORE CKC 1 URL3763 0.00 CKC 1 UVN6314 0.00 CKC 5621 URI1126 1.00 CKC 1 UTR5794 0.00 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| VBA | Excel Worksheet Functions | |||
| Count Function | Excel Worksheet Functions | |||
| How do I add the count function to the toolbar? | Excel Worksheet Functions | |||
| Can I count in an array based on a function? | Excel Worksheet Functions | |||
Threaded Mode
