Hello Again

Thanks for all the help so far. Here is a formula that calculates all the 16 gauge material on a project. It looks at a number of cells that refer to sheet metal. If the cells have 16(b79=16)in them then it adds up the sq feet in the column to the right. This works great, but im trying to simplify it, so that anyone else can understand whats going on. Any ideas?

=IF(C$42=B79,$D$42)+IF($C$43=B79,$D$43)+IF($C$44=B79,$D$44)+IF($C$45=B79,$D$45)+IF($H$42=B79,$I$42)+IF($H$43=B79,$I$43)+IF($H$44=B79,$I$44)+IF($H$45=B79,$I$45)+IF($H$46=B79,$I$46)+IF($C$5=B79,$D$5)+IF($C$6=B79,$D$6)+IF($C$7=B79,$D$7)+IF($C$8=B79,$D$8)+IF($H$5=B79,$I$5)+IF($H$6=B79,$I$6)+IF($H$7=B79,$I$7)+IF($N$43=B79,$O$43)+IF($N$5=B79,$O$5)+IF($N$6=B79,$O$6)+IF($N$7=B79,$O$7)+IF($N$8=B79,$O$8)+IF($S$5=B79,$T$5)+IF($S$6=B79,$T$6)+IF($S$7=B79,$T$7,0)