how to add cost codes and add running totals to a cell

Alright, rookie here, so I want to make a formula that says: if(B1=1, then put the number in A1 in D1, (if A2=2, then put the number in A1 in D2, (if A2=3 then...) and so on until A2=5

I hope that makes sense. Thank you in advance for any help.

Let's try this another way.

I have $ values from receipts in A1 and I want to cost code them in B1 (with the numbers 1-5) then send the number in A1 to say D1,2,3,4, or 5 based on the cost code. I want to make a pattern in columns A and B to add $ values and cost codes and if possible make the numbers go to D1,2,3,4 and 5 as running totals (i.e. keep adding everything that's cost coded "1" to cell D1).

you could
in D1 put

=if(b1=1, a1, "")

are we using A2 or B1 or both ?

in d2 put
=if(b1=2, a2, "")

in d3 put
=if(b1=3, a3, "")

this could be made to copy down using row()
just not sure now as i'm confused what you want now - reading through the question

Hi, welcome to the forum

your request is a bit confusing...

if(B1=1, then put the number in A1 in D1
if A2=2, then put the number in A1 in D2,
if A2=3 then....
and so on until A2=5

is B1 a typo?

Thanks etaf, your solution does work but now I also want to also make D1 a running total of values from column A (i.e. when I enter a number in A2 and cost code it 1 in B2 I want it to add to the number already in D1)

Sorry, I made an edit to my first post that will hopefully help clarify.

can you mock up an example

Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "Choose File" (top Left corner).
Find your file, click "Open" click "upload" click 'close windows" Top Right. click "Submit Reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

use SUMIF()
=SUMIFS($A$7:$A$11,$C$7:$C$11,1)
=SUMIFS($A$7:$A$11,$C$7:$C$11,2)
=SUMIFS($A$7:$A$11,$C$7:$C$11,3)
=SUMIFS($A$7:$A$11,$C$7:$C$11,4)
=SUMIFS($A$7:$A$11,$C$7:$C$11,5)
see attached
i have hardcoded 1,2,3,4,5 - but we could take those from the description
=SUMIFS($A$7:$A$11,$C$7:$C$11,LEFT(E7,1))
and copy down

sorry I used sumifs() - still works
so does SUMIF()
=SUMIF($C$7:$C$30,LEFT(E7,1),$A$7:$A$30)

you are welcome