Count number of cells based on a date in one column and a money value in another

[redsheep79]

I have column A with various dates over a year (these are full dates, not just months) I have column B with financial savings figures (some of which will be 0 or blank - they can be either/or, whatever is easiest)

I want to get data, by month, that tells me the amount of cells in column B that have a figure in there (or figure above 0).

Essentially I want to know the success rate. So if in April there are 20 dates and 15 of this return a figure above 0 I want to be able to show that.

Can't work out at all what formula to use or if I can return anything via a pivot table.

Thank you.

I've not found anything that can work, maybe if I created some sub-tables it might help but trying to avoid that.

Thank you

[AliGW]

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Administrative Note:

Is your forum profile showing the Excel PRODUCT that you need this to work for?

Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.

The three most recent Excel products are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.

Thanks.