| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNT IF FUNCTION
Use SUMPRODUCT: =SUMPRODUCT(--(B2:B5=1),--(D2:D5=0.00))
Dave -- Brevity is the soul of wit. "nperpill" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNT IF FUNCTION
=SUM(IF((B2:B100=1)*(D1:D100=0),1))
or =SUM((B2:B100=1)*(D1:D100=0)) Ctrl+Shift+Enter on both formula above, not just enter "nperpill" wrote: 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 |
| Reply |
| 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 | |||
Hybrid Mode
