I have 2 working formulas that I wish to combine.
The first is a count where MSD Data field = Yes - it works and gives me a result of 65
=COUNTIFS([MSD Product]:[MSD Product], ="Yes")
The second is a complex formula with dates (that this community helped me construct genius that they are) which gives me a count in the previous calendar month i.e January - you can see why I needed help !!!
=COUNTIFS([Raised on]:[Raised on], AND(IFERROR(MONTH(@cell), 0) = MONTH(DATE(YEAR(TODAY()), MONTH(TODAY()), 1) - 1), IFERROR(YEAR(@cell), 0) = YEAR(DATE(YEAR(TODAY()), MONTH(TODAY()), 1) - 1)))
What I need to achieve, and cannot seem to get to work, is where the MSD Data field = Yes and the Raised On field was last month.
I've tried adding the MSD part to the front then a comma then the raised on etc. I have also tried adding the MSD field to the end and after another AND but doesn't work.
so for example this doesn't work and gives #unparseable error
=COUNTIFS([Raised on]:[Raised on], AND(IFERROR(MONTH(@cell), 0) = MONTH(DATE(YEAR(TODAY()), MONTH(TODAY()), 1) - 1), IFERROR(YEAR(@cell), 0) = YEAR(DATE(YEAR(TODAY()), MONTH(TODAY()), 1) - 1)) AND ([MSD Product]:[MSD Product], ="Yes"))
I have passed my ability to compute this and really hope that you can help.
