Hi,

I'm getting very confused with countif(s) and month() and the possible use of Sum() or Sumproduct(). I would just like to be able to count the number of times a particular number comes up in column B if the month of the date (dd/mm/yyyy) in column A is, say, January.

Help, please!

Thank you for any guidance.

Cheers,
notwen