Formula for Identifying letter with sum value

Closed
bw-777
Posts
2
Registration date
Friday March 8, 2013
Status
Member
Last seen
March 8, 2013
- Mar 8, 2013 at 11:11 AM
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
- Mar 11, 2013 at 02:01 PM
Hello,


I am new to Excel and know very basic formulas. I have made a spreadsheet and have everything pretty much ok except for one part I need help with. It looks like this:

wk1 code wk2 code wk3 code wk4 code wk5 code
jan
feb
mar
etc...

in the "code" column will be one of the following letters - B Y M H A. In the wk1-wk5 column will be currency sums. I need a formula that will allow me on a seperate worksheet to be able to identify each code and return the sum value of each week for each month.

Thank you for your assistance.


3 replies

Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
68
Mar 8, 2013 at 02:39 PM
Hi bw-777,

A little clarification will help here. From your post it is not clear as to what format your next sheet should look. A more clear explanation about your expression "identify each code and return the sum value of each week for each month" will help me figure out the actual situation. If you have a sample file you can upload the same here:

https://authentification.site

Note: Before you upload any files please make sure there is no personal or confidential information contained in it.

Please do write back to us.
0
bw-777
Posts
2
Registration date
Friday March 8, 2013
Status
Member
Last seen
March 8, 2013

Mar 8, 2013 at 10:49 PM
I am uploading a copy of the worksheet for you to see. On the first worksheet "giving" you will see two different columns, one for "general" and the one on the right for "other." In the one on the right you will see the month, week and a space beside each week for a code (or letter) that you will see directly below each of the entries. Under the tab, "summary of giving" you will see that I have one table set up already for the "general" account. What I need is to make another table in that same worksheet that will reflect the "other" account under the "giving" worksheet as it relates to each of those code letters. For example:

wk1 code wk2 code wk3 code wk4 code wk5 code
jan 1.00 a 3.00 b 4.00 m 5.00 y 3.00 h
feb 3.00 m 3.00 h 3.00 y 2.00 b 2.00 a
mar
etc.

I need someone to show me how to write a formula that will tell the "cell" that formula is in to reflect the "sum" total of wk1 if code equals (whatever letter happens to be there) all the way down through the "giving" worksheet. I hope that makes sense.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Mar 9, 2013 at 09:14 AM
@bw-777 : you need to post the link to the file back here for Zohaib to have access to it
0
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
68
Mar 11, 2013 at 02:01 PM
Hi bw-777,

Thank you for your explanation, but posting a Sample File will be much more beneficial and will give me a clear picture. Kindly upload the same here:

https://authentification.site

Please do write back to us.
0