Sum/if/count etc from 1 tab to another

[Ira Hopkins]

Hi

I have a spreadsheet with 2 tabs. 1 is called histories and the other is order- ( it wont let me do add in to attach file as work fire walls to do as attachment)
I need the type on histories to fill in ok if more than one entry on orders but if only one entry to say exactly what is on type column in order tab. Also if the code appears more than once on order tab I need to add together for histories tab on the total column and again if not put what it is from order tab. Thanks so much
Top is the order tab and bottom is history tab-

Code	date	Type	Total
F2091	01/05/2024​	Normal	£10​
F2092	02/05/2024​	Normal	£10​
F2093	03/05/2024​	Normal	£10​
F2094	04/05/2024​	Normal	£10​
F2095	05/05/2024​	Normal	£10​
F2096	06/05/2024​	Normal	£10​
F2097	07/05/2024​	Normal	£10​
F2098	08/05/2024​	Normal	£10​
F2099	09/05/2024​	Normal	£10​
F2100	10/05/2024​	Normal	£10​
F2091	01/05/2024​	Urgent	£12​
F2092	02/05/2024​	Urgent	£12​
F2093	03/05/2024​	Urgent	£12​

Code	date	Type	Total
F2091
F2092
F2093
F2094
F2095
F2096
F2097
F2098
F2099
F2100
F2091
F2092
F2093

 

[awoohaw]

Its worked thank you so much for all your help greatly appreciatted

my pleasure.

Best Wishes!

(PS you still need to update your profile so the your excel version appears on your chat button).