Previous Topic Next Topic

Excel help

Closed
ririz99 - Jun 5, 2010 at 10:23 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 6, 2010 at 02:42 PM
Hello,

I have an excel spreadsheet which I used to keep track of some records. A sample as below:

ColumnA ColumnB
Row1 07/09/09 5
Row2 08/09/09 -2
Row3 13/09/09 10
Row4 02/10/09 12
Row5 31/01/10 -22
...
...
...
Row50

Column A is where I put a date in ddmmyy format.
Column B is an integer value

Appreciate if someone could write a formula that does the following:

1. Ability to scan row1 to row50 on columnA, return me the sum of the integers from columnb for that month. Note, some months there are more than 1 record and some months there are 0 records.

The results should look something like this:

Sep-09 13
Oct-09 12
Nov-09 No records
Dec-09 No records
Jan-10 -22

If there are months with 0 records then I want the text "No records' to appear.

Tks
ririz99

Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 5, 2010 at 10:49 AM
By return, are you saying that a sort of summary sheet should be created for all the months in the sheet. ? need more information about the date range and how you are looking to get the total
ririz99
Jun 6, 2010 at 04:00 AM
Hi rivisa1,

Thanks for responding. Using the above as example, for month of sep 09, I have 3 records. If you manually sum it up, it will give you a result of 13 (5 + (-2) + 10) = 13.

However, the number of records varies each month, sometimes more sometimes less and sometimes zero record.

It will be good to have a formula to automatically sum up the records based on month by month.

Rgds
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 6, 2010 at 06:24 AM
I understand the sum part, What I don't understand is how that sum in being used/called. I can call it in various ways
1. on a given cell i will say for this month and for this month only give me a sum
2. i can have a list of month generated automatically and have their sum
3. i can have all the months written on a sheet and have the sum filed in for those months.
4. There can be multiple years in the data and i want for each year the monthly totals
and list goes on....

I hope you get what I was asking before as your answer still is silent on those lines. You have to go into far more detail about "how" part
ririz99
Jun 6, 2010 at 10:02 AM
Hi rivisa1,

Is there anyway I can email the spreadsheet across to you? My email is mechrex@gmail.com.
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 6, 2010 at 02:42 PM
You upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ , http://www.editgrid.com etc and post back here the link

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses