How to calculate cost incured per day for a product or commodity in excel?
1 Answer(s)
Sanjoy
Yes, you can certainly calculate anything in Microsoft Excel.
To calculate Cost/ Day you can use inbuilt functions AVERAGE or AVERAGEIF functions. AVERAGE function if list contains cost of single product or commodity and AVERAGEIF function if you have more then one products cost on the list and you want to calculate cost per day for a particular commodity.
Lets explain this further with the help of below mentioned illustration:
Suppose, You have below mentioned list of expenses incurred listed out in an Excel Spreadsheet starting from top left corner i.e. A1
Product Cost Date
Books & Periodicals 1000 03-Apr-14
Books & Periodicals 12000 05-Apr-14
Books & Periodicals 1200 07-Apr-14
Travelling 500 07-Apr-14
Carriage & Cartridge 48 10-Apr-14
To calculate Cost/Day for Books and Periodicals use below mentioned formula
=AVERAGEIF(A2:$A$6,$A$2,$B$2:$B$6)
Hopefully, This has explained and answered your question. Let me know if it does :)
Apr 20 2014 02:24 PM
To calculate Cost/ Day you can use inbuilt functions AVERAGE or AVERAGEIF functions. AVERAGE function if list contains cost of single product or commodity and AVERAGEIF function if you have more then one products cost on the list and you want to calculate cost per day for a particular commodity.
Lets explain this further with the help of below mentioned illustration:
Suppose, You have below mentioned list of expenses incurred listed out in an Excel Spreadsheet starting from top left corner i.e. A1
Product Cost Date
Books & Periodicals 1000 03-Apr-14
Books & Periodicals 12000 05-Apr-14
Books & Periodicals 1200 07-Apr-14
Travelling 500 07-Apr-14
Carriage & Cartridge 48 10-Apr-14
To calculate Cost/Day for Books and Periodicals use below mentioned formula
=AVERAGEIF(A2:$A$6,$A$2,$B$2:$B$6)
Hopefully, This has explained and answered your question. Let me know if it does :)