Excel formula
This query is : Resolved
Querist : Anonymous
Querist :
Anonymous
(Querist)
10 May 2013
I have a sales data. This data contains the daily sales.
I want to find out the sum of the sales for a particular period within the data.
Eg. sales for 1st to 30th April is given.
I want to find the sum of the sales for 1 - 7 April, 15-25 April.
Kindly help.
I want to find out the sum of the sales for a particular period within the data.
Eg. sales for 1st to 30th April is given.
I want to find the sum of the sales for 1 - 7 April, 15-25 April.
Kindly help.
15 May 2013
1)TAKE DAILY SALES REGISTER
2)INSERT A ROW IN LEFT TO DATE COLOUMN OF REGISTER, EXTRACT DATE FROM DATE COLOUMN
3)APPLY IF FUNCTION AND MAKE IT INTO TWO DIFFERENT GROUPS
LIKE
=IF((CELLREFERNCE)>8,8,9)
AFTER APPLYING ABOVE FORMULA TO NEW COLOUMN FOR WHICH ALREADY WE HAVE EXTRACTED DATE.
4)AFTER THAT EXTRACT MONTH AND DO CONCATENATE FORMULA TO DATE AND MONTH
DO CONCATENATE FORMULAE ONCE AGAIN TO VALUE OF 4 TO VALUE ARRIVED AFTER APPLYING FORMULAE AS PER 4
5)NO DO SUM IF IT WILL GIVE YOU YOUR DESIRED VALUES,
2)INSERT A ROW IN LEFT TO DATE COLOUMN OF REGISTER, EXTRACT DATE FROM DATE COLOUMN
3)APPLY IF FUNCTION AND MAKE IT INTO TWO DIFFERENT GROUPS
LIKE
=IF((CELLREFERNCE)>8,8,9)
AFTER APPLYING ABOVE FORMULA TO NEW COLOUMN FOR WHICH ALREADY WE HAVE EXTRACTED DATE.
4)AFTER THAT EXTRACT MONTH AND DO CONCATENATE FORMULA TO DATE AND MONTH
DO CONCATENATE FORMULAE ONCE AGAIN TO VALUE OF 4 TO VALUE ARRIVED AFTER APPLYING FORMULAE AS PER 4
5)NO DO SUM IF IT WILL GIVE YOU YOUR DESIRED VALUES,
15 May 2013
YOU CAN UNDERSTANDARD THIS PROVIDED IF YOU HAVE COMMAND OVER EXCEL FORMUALES
IF FUNCTION,CONCATENATE,HOW TO EXTRACT DATE,AND SUMIF FUNCTION
TO GET KNOWLEDGE ON THIS GET SOME HELP FROM WEB TO UNDERSTAND THIS FORMULAES
YOU MAY NOT FIND EXTRACT FORMULAE LET ME GIVE YOU..
1) DATE=01-04-2012 THEN DO
=LEFT((CELLREFERENCE),2)
OR
=MONTH(CELL REFERENCE)(IT MAY HAVE SOME LIMITATIONS)
IF FUNCTION,CONCATENATE,HOW TO EXTRACT DATE,AND SUMIF FUNCTION
TO GET KNOWLEDGE ON THIS GET SOME HELP FROM WEB TO UNDERSTAND THIS FORMULAES
YOU MAY NOT FIND EXTRACT FORMULAE LET ME GIVE YOU..
1) DATE=01-04-2012 THEN DO
=LEFT((CELLREFERENCE),2)
OR
=MONTH(CELL REFERENCE)(IT MAY HAVE SOME LIMITATIONS)
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Gst registered proprietorship firm
- TDS Challan - change of FY 2025-26 to TY 2026-27
- AUDITOR APPOINTMENT FOR THE YEAR ENDING MARCH 27
- SALARY CAN BE CAPITALIZE
- UDIN ISSUE
- TDS on purchase of under construction property from a reseller
- Non filing of I T Returns
- GST Intimation due to Government took possession of Business Premises under PPE Act
- TDS on Fixed Assets purchased
- GST on Renting godown to KFCSC for Storage of Raagi
- How to Handle Active E-Invoices in GST Portal Deleted from Tally?
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Starting trading business
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
