I currently have an excel document that uses the sumif formula. Currently, it
checks column E for a specific word (in this case "Hydrogen") It then takes
all the rows with "hydrogen" and adds up the numbers in the N column for
those respective rows.

My problem is that I need to turn this process into a macro rather than
relying on a formula. Any direction on how to code this? I know it should be
fairly simple but I'm a VBA novice.

Thanks in advance!