Help not sure what i'm doing
 

I am trying to make a book keeping record in excel, I have eveything working
but one thing. This is how I have it mapped out, my sheets are named page 1
of jan, page 2 of jan and so on to dec. On page 1 G, H, and I columns I put
the date how I paid and check # in column J is where I put a acct# and K the
amount. On page 2 column F I have a list for 1 to 31 of accts. and in G the
name of the accts in column H is the total for the month. What I want it to
do is when I put in a acct. # on page 1 and a amount I want it to go to page
2 in the totals column. For example if I have entered 3 in J5 and $100.00 in
K5 and 3 in J6 and $200.00 in K6, I want it to total in page 2 In my H column
for that account.
I don't know if there is a formula for that or not. Thanks a lot if you can
help me.

Help not sure what i'm doing
 

Doug,

I think that you want to use the sumif function on the summary sheet.

The sumif function works sums a range based on the key. Check the help for a
better description.

--
HTHs Martin


"Doug" wrote:

I am trying to make a book keeping record in excel, I have eveything working
but one thing. This is how I have it mapped out, my sheets are named page 1
of jan, page 2 of jan and so on to dec. On page 1 G, H, and I columns I put
the date how I paid and check # in column J is where I put a acct# and K the
amount. On page 2 column F I have a list for 1 to 31 of accts. and in G the
name of the accts in column H is the total for the month. What I want it to
do is when I put in a acct. # on page 1 and a amount I want it to go to page
2 in the totals column. For example if I have entered 3 in J5 and $100.00 in
K5 and 3 in J6 and $200.00 in K6, I want it to total in page 2 In my H column
for that account.
I don't know if there is a formula for that or not. Thanks a lot if you can
help me.

Help not sure what i'm doing
 

I couldn't make that work. Any one else have any suggestion.

"Martin Fishlock" wrote:

Doug,

I think that you want to use the sumif function on the summary sheet.

The sumif function works sums a range based on the key. Check the help for a
better description.

--
HTHs Martin


"Doug" wrote:

I am trying to make a book keeping record in excel, I have eveything working
but one thing. This is how I have it mapped out, my sheets are named page 1
of jan, page 2 of jan and so on to dec. On page 1 G, H, and I columns I put
the date how I paid and check # in column J is where I put a acct# and K the
amount. On page 2 column F I have a list for 1 to 31 of accts. and in G the
name of the accts in column H is the total for the month. What I want it to
do is when I put in a acct. # on page 1 and a amount I want it to go to page
2 in the totals column. For example if I have entered 3 in J5 and $100.00 in
K5 and 3 in J6 and $200.00 in K6, I want it to total in page 2 In my H column
for that account.
I don't know if there is a formula for that or not. Thanks a lot if you can
help me.

Help not sure what i'm doing
 

Thank You Martin sumif did work after I entered it wright.

"Martin Fishlock" wrote:

Doug,

I think that you want to use the sumif function on the summary sheet.

The sumif function works sums a range based on the key. Check the help for a
better description.

--
HTHs Martin


"Doug" wrote:

I am trying to make a book keeping record in excel, I have eveything working
but one thing. This is how I have it mapped out, my sheets are named page 1
of jan, page 2 of jan and so on to dec. On page 1 G, H, and I columns I put
the date how I paid and check # in column J is where I put a acct# and K the
amount. On page 2 column F I have a list for 1 to 31 of accts. and in G the
name of the accts in column H is the total for the month. What I want it to
do is when I put in a acct. # on page 1 and a amount I want it to go to page
2 in the totals column. For example if I have entered 3 in J5 and $100.00 in
K5 and 3 in J6 and $200.00 in K6, I want it to total in page 2 In my H column
for that account.
I don't know if there is a formula for that or not. Thanks a lot if you can
help me.