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...
Hi JMc21,
This is possible, please attached the sample file with your desired results.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more
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