Posts by legin52

  • Count values based on multiple criteria

    Re: Count values based on multiple criteria


    Thank you and in particular for the quick response. This is my first submit to my first forum and as such all advise is taken on board and I will remember for next time Once again a heart felt thank you.

  • Count values based on multiple criteria

    I have a table; in column B are randomly repeated sets of 13 core numbers. Each number relates to a Day in column D and a shift (either Nights or Days) in column E.
    I would like to be able to count how many times each number is used in the day/shift.
    Eg “number”? = 5 (times) in Monday day shift.
    All help would be gratefully received – and I mean gratefully!