Forum Discussion
Excel formula help
Hi I’m hoping someone might be able to tell me whether its possible to create a formula that I’m looking for. I’ve been trying all sorts of Countif and countifs but with no luck and its probably bey...
Really appreciate you responding but I can't see an attached file that you referred to!
Regards
Jay
I've managed to attach a file - I hope it makes sense from what I've described in the first message. I'm looking for the formula to calculate how many of the payments were cash in the last 12 months from today's date but unsure of how to do it.
Many thanks
Jay