Complex countif

Originally Posted by brad.tho

Thanks Ratcat,

The screenshot in my first post is pretty much what im using, only where the 4 zero's are is where im trying to get the data breakdown to go. There are no other formulas in the screenshot that ive posted.

Anyway, its attached for good measure. Good luck! Thanks for all your help so far! Keep it up!

Well,..... here it is


Is that it ???? I looked like there was the code information double up ??

This what I......hmm workout.

Edit: I forgot. Just entered the a code then a "AM" or "PM in front of "Swift" name then look at the count in the boxes on the right hand side of the sheet.

Maybe this?
It requires you have a vlookup on another column.
What you must have is a list of all codes so the vllokup works for everything.