how to calculate count & percentage form data base based on current month & previous month
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.??
attached file for your convenience.
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By losincog in forum Excel Formulas & Functions
Last Post: 09-04-2020, 04:02 PM
By kay007 in forum Excel Formulas & Functions
Last Post: 11-19-2015, 11:19 AM
By ElmerFud in forum Excel Programming / VBA / Macros
Last Post: 08-05-2015, 03:02 PM
By Yu Marquez in forum Excel Formulas & Functions
Last Post: 02-21-2014, 12:42 AM
By srinivasan1965 in forum Excel Programming / VBA / Macros
Last Post: 10-07-2012, 03:45 AM
By Tracyann in forum Excel General
Last Post: 10-04-2012, 07:06 AM
By ravikumar00008 in forum Excel General
Last Post: 07-26-2012, 10:04 AM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1