ExcelBanter - Question Involving COUNTIF and Possibly DCOUNTA

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Question Involving COUNTIF and Possibly DCOUNTA (https://www.excelbanter.com/excel-worksheet-functions/152474-re-question-involving-countif-possibly-dcounta.html)

Piscator

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))))}

All times are GMT +1. The time now is 07:05 PM.