Help not sure what i'm doing

[Doug]

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.

[Martin Fishlock]

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.

[Doug]

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.

[Doug]

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.