here is my formula
=SUMIF(A$65:A$151,"AWM",E$65:E$151)*24
instead of having to type the name of the project in each formula in this case "AWM" I would like it to look up the job name from a list of cells
in the work sheet I have a column with a list of job names that are extracted from another worksheet ='JOB CODES'!B3 this = the job name AWM
I would like to be able to extract these name from that worksheet =SUMIF(A$65:A$151,"='JOB CODES'!B3",E$65:E$151)*24
how can I do this
=SUMIF(A$65:A$151,"AWM",E$65:E$151)*24
=SUMIF(A$65:A$151,"496",E$65:E$151)*24
=SUMIF(A$65:A$151,"goldilock",E$65:E$151)*24
Bookmarks