I am trying to figure out a formula that will only count how many cells in column B2:B500 equal 31 IF column G has the right month in it.
So how many times did column B2:B500 equal 31 in October. The date is in column G2:G500 in the 31/12/2016 format.
The year is not relevant as I have to run this by financial year so I need to make sure that it is not included.
thanks
Bookmarks