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.

Ganeshbabu K

Ganeshbabu K (Expert)
Follow

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,

Ganeshbabu K

Ganeshbabu K (Expert)
Follow

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)

Upgrade to CAclubindia Pro. Subscribe Now!