Hello,
I'm having some troubles working with the COUNTIFS formula gathering information from the pivot table shown below. (it is actually larger but the idea is the same)
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I need to be able to count for each SupplierNr. in the first collumn how many times a problem occurs.
So for R00000162 and 03-KWALITE that would be 1, for R00000162 and 01-VEILIG that would be 4 etc.
The easy way to do this is by making use of the COUNTIFS formula but this does not seem to work although the two seperate COUNTIF formulas do. and that is what i cannot seem to understand.
=countif(A1:A1000,R00000162) Works
=countif(D1:D1000,"03-LOGISTI") Works
=countifs(.... Doesn't work.
How is this possible and how can this be avoided? either with COUNTIFS or another (Array)formula
thanks in advance
I'm having some troubles working with the COUNTIFS formula gathering information from the pivot table shown below. (it is actually larger but the idea is the same)
SupplierNr. | Descrption | Number | Problem |
R00000162 | ior 1503104. GEEN THT VERKEERDE MAAT SLECHT | M150830 | 03-KWALITE |
R00000162 | Een SO2 resultaat voldoet niet aan de EU-norm | M160606 | 01-VEILIG |
R00000162 | glas in pinda's. 1409210. reactie van Belfrudis | M141324 | 01-VEILIG |
R00000162 | steentje in pinda's. lot 15-28, tht 02/2016. | M150932 | 01-VEILIG |
R00000162 | teveel SO2 in rozijnen. Belfrudis klacht verstuurd | M140700 | 01-VEILIG |
R00000173 | teveel Chloraat in sample. Berrico klacht | M160030 | 01-VEILIG |
R00000204 | 06-05 Hanos order niet geleverd op afgesproken dag | M150455 | 07-LOGISTI |
R00000204 | 1 emmer schade Kaashuis Dorestad Wijk bij Duursted | M160577 | 07-LOGISTI |
R00000204 | 2/3 juni te laat bij Rene Tiel om te laden | M150548 | 07-LOGISTI |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I need to be able to count for each SupplierNr. in the first collumn how many times a problem occurs.
So for R00000162 and 03-KWALITE that would be 1, for R00000162 and 01-VEILIG that would be 4 etc.
The easy way to do this is by making use of the COUNTIFS formula but this does not seem to work although the two seperate COUNTIF formulas do. and that is what i cannot seem to understand.
=countif(A1:A1000,R00000162) Works
=countif(D1:D1000,"03-LOGISTI") Works
=countifs(.... Doesn't work.
How is this possible and how can this be avoided? either with COUNTIFS or another (Array)formula
thanks in advance