how to calculate count & percentage form data base based on current month & previous month
hello everyone
in my database accepted/rejected data are available. i need count & percentage of accepted & rejected in every month and accepted after rejection within the current month and previous month. how can i calculate this.??
Re: how to calculate count & percentage form data base based on current month & previous m
In the attached version of your file I've added a simple helper column (D) that calculates how many were rejected since the start of the previous month.
Then I've added several COUNTIFS formulas in column I. Easier if you look at them there than if I explain them here, but feel free to ask any follow up questions.
Bookmarks