Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question Involving COUNTIF and Possibly DCOUNTA
....and yet another way
{=SUM(IF($A$1:$A$11="N",IF($B$1:$B$11=4,1,IF($B$1: $B$11=5,1,0))))} |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question Involving COUNTIF and Possibly DCOUNTA | Excel Worksheet Functions | |||
Question Involving COUNTIF and Possibly DCOUNTA | Excel Worksheet Functions | |||
Question Involving COUNTIF and Possibly DCOUNTA | Excel Worksheet Functions | |||
Question Involving COUNTIF and Possibly DCOUNTA | Excel Worksheet Functions | |||
Question Involving COUNTIF and Possibly DCOUNTA | Excel Worksheet Functions |