r/excel•
Ricotta1430

Using two COUNTIFS functions together not yielding the desired result.

unsolved

I've been having this issue at work using the Countifs function to count cells in two different columns that match the date and malfunction specified. The first screenshot is the "Totals" sheet and the second is the "Causes" sheet. The Julian date on the "Cause" sheet needs to match the Julian date on the "Totals" sheet's B2:AF2 in order to be counted. It must also match the malfunction code specified (Eng for example). I wasn't able to get the one from work so I drafted this up quick to replicate the problem. In my work model, for some dates it's counting way more codes on one day then are actually in the column. On the one I just drafted, it is counting the incorrect things all together. Combining the two columns in the "Causes" sheet isn't an option considering how the formulas are set up on the actual model. Please reference the below screenshots and let me know if you need more context.

https://preview.redd.it/9vv7t8f5lbra1.png?width=2125&format=png&auto=webp&v=enabled&s=951c4b750beda67effe76d917e811c0fbd4e611a

https://preview.redd.it/a5caz5j7lbra1.png?width=629&format=png&auto=webp&v=enabled&s=9728eadbf7074442755042009a2238026a7c68f9

Posted Apr 1, 2023, 7:00 PM UTC

1513
Loading comments…