Using SUMIF with specific assigned values

[ExcelGuy12345]

Hi!

I'm trying to compile a total time for a job by referencing the name of the job's component.

I'd like to be able to assign a value of 1 minute to "filing", 2 minutes to "retrieval", 1 minute to "processing", etc. and have the time compile based upon the job entered in the column. I understand this should be fairly basic, but I can't seem to get it to work out right. Any help would be much appreciated. Thanks!

 

[bs0d]

Hmm, it seems you could build a reference table that lists the jobs in one column, and the time associated with the job in the column next to it. Then for your time, list each of the jobs you're evaluating. Use a vlookup formula to point to the job in question, and return the time that matches the job in the table you built. At the bottom, just sum the time for the total?

=vlookup(job name, table range, column number containing the desired value, FALSE for exact match)

 

[SpillerBD]

SUMIF or SUMIFS, I hardly ever use.
My first choice is to perform any summary via a Pivot Table.
My second choice, I use Tables, is to place a SUBTOTAL(9,...) above the Table and utilize filters or even Table Slicers.

 

[Learn Excel in Tamil]

Hi using look up function, if this is not your expected result pls reply back

 

[Joe4]

Links back to your computer obviously won't work.

There are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

 

[ExcelGuy12345]

Thank you! I'm having trouble with the end of the formula, I think.

Mine looks like this: =VLOOKUP("SAW",SHEET2!,$A$1:$B$3,FALSE) and I'm getting an error message.

 

[ExcelGuy12345]

Okay, my VLOOKUP is working correctly, but now I need to have the keyword (in this case, my job) in Column "B" trigger the VLOOKUP in Column "F". Is there a way to do this?

 

[Melvin88]

Mine looks like this: =VLOOKUP("SAW",SHEET2!,$A$1:$B$3,FALSE) and I'm getting an error message.
Okay, my VLOOKUP is working correctly, but now I need to have the keyword (in this case, my job) in Column "B" trigger the VLOOKUP in Column "F". Is there a way to do this?

First off, your vlookup is missing the column number of which column you're attempting to pull the information from. =VLOOKUP("SAW",SHEET2!,$A$1:$B$3,2,FALSE) I put "2" as a place holder to show where you're vlookup is failing.

Use this in your column F cells to return the values you're looking for. Without knowing the table range of columns you're attempting to return I just returned the second (2) column within the table array. Change it to fit your file.

=IF(COUNTIF($B:$B,"MY JOB"),VLOOKUP("MY JOB",$B:$C,2,FALSE),"")