formula

[marf85]

Hi all,
ive designed a spreadsheet for my accounting and im after a little help if anyone can please.

within my sheet i have created a column with a drop down containing all the nominal codes. on sheet 2 which is my working sheet for formulas, i have the full list of codes. now, if a code is used in the accounting side, i would like a total kept next to the nominal codes on sheet 2. so at the end of the month i can see exactly how much has been spent against each nominal code. ive exhausted my skills though and just cant make a formula work, anyone able to help? please?

thanks
Jez

 

[njimack]

=SUMIF(List_of_codes,Code_you_wish_to_sum,List_of_amounts)

 

[marf85]

=SUMIF(List_of_codes,Code_you_wish_to_sum,List_of_amounts)

Thanks njimack, i still cant get it to work though. heres what ive put

=SUMIF(B1:B147,Sheet1!G4:G70)

page 1 has the accounting sheet and page 2 is the working sheet with the nominal codes listed down the columns. i may need a more simple explanation? many thanks

 

[njimack]

And which cell has the nominal you want the sum of?

 

[marf85]

And which cell has the nominal you want the sum of?

sheet 1 - cells G4-G70 is the column with the drop down list
sheet 2 - cells B1-B147 contain that actual list and im try t make a total next to each one in C1-C147

 

[marf85]

hi guys can anyone else help on this?

 

[markmzz]

hi guys can anyone else help on this?

Hi!

Try this in H4 (Sheet1) and copy down

=SUMIF(Sheet2!$B$1:$B$147,G4,Sheet2!$C$1:$C$147)

	F	G	H	I			A	B	C	D
1				Sheet1		1		Code001	835	Sheet2
2						2		Code002	879
3		List	Result			3		Code003	619
4		Code001	8302			4		Code004	345
5		Code002	7667			5		Code005	519
6		Code003	7240			6		Code006	162
7		Code004	9100			7		Code007	606
8		Code005	6928			8		Code008	500
9		Code006	7377			9		Code009	521
10		Code007	6320			10		Code010	310
11		Code008	6489			11		Code001	612
12		Code009	7895			12		Code002	781
13		Code010	7563			13		Code003	747
***	**	*********	********	********	**	***	**	********	******	********

<tbody>
</tbody>

Markmzz

 

[marf85]

many thanks but it didnt work, came up with too many arguments. im really stuck on this one.

 

[markmzz]

many thanks but it didnt work, came up with too many arguments. im really stuck on this one.

Here all is Ok. Like you can see in my last post.

Could you post the formula that you used?

Markmzz

 

[marf85]

Here all is Ok. Like you can see in my last post.

Could you post the formula that you used?

Markmzz

i copied your formula direct and planned to edit it. this time it comes up with an open box asking me to update values in sheet 2