Counting Errors

[tai1017]

Can you please assist with the following? I am trying to count the number of errors by pay types in columns E to J in tab “REF. DAILY DATA” If there is more than one error in one day, count 1 error per day, see highlighted in yellow.

Thanks in advance

 

[Special-K99]

FYI

You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html

 

[Macropod]

Cross-posted at:
https://www.excelforum.com/excel-formulas-and-functions/1265238-counting-errors.html
https://www.ozgrid.com/forum/forum/help-forums/excel-formulas/1215086-counting-errors
Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html