Countif, Countifs or IF?

user3309798 Source

I'm a bit lost with a formula, I'm not sure which is the best to us for the below.

I have BU_Description for each for each document type.

PPForm      , Employment_Agreement, ID      , POR, BU_Description
Not Received, Received            , Received,Received, HR
Not Received, Received            , Received,Received, warehouse
Not Received, Not Received        , Received,Received, warehouse
Not Received, Received            , Received,Received, HR

I need to run a count for each BU_Description how many documents were received.

Example

BU_Description , PPFORM                        ,Employment_Agreement          , ID         ,
  HR           , Received "0" Not Received "4" , Received "2" Not Received "0", Received "2" Not Received "0",

enter image description here

Result enter image description here

excelexcel-formula

Answers

answered 2 years ago Doug Coats #1

Oh then you can drop a SUM formula anywhere on the sheet you'd like, and just double up the efforts. 1 for received & one for not recieved. you probably can use a "totals" row at the bottom.

=SUM(range)

answered 2 years ago Axel Richter #2

enter image description here

enter image description here

Formula in H3 filled to right and downwards:

=COUNTIFS($E:$E,$G3,INDEX($A:$E,,INT((COLUMN(A:A)-1)/2)+1),H$2)

comments powered by Disqus