hi Friend, just use this formula in C7
=SUMIFS(C1:C5,$A$1:$A$5,A6,$B$1:$B$5,B6) make sure that your A7 and B7 must have values used in critreria. Regards Prince On Wednesday, March 13, 2013 7:07:02 PM UTC+5:30, cca...@gmail.com wrote: > > > I'm trying to create an employee expense form. The logic I'm trying to > solve is to auto-populate single cells based on data entered in a separate > range of cells by merging the common entries. > > For example: > 1) in cells A1:A5, the user will TYPE IN the following job numbers: A1=AG, > A2=Waterfront, A3=CN, A4=AG, A5=CN > 2) in cells B1:B5, the user will select from a predefined LIST: > B1=Mileage, B2=Meals, B3=Supplies, B4=Mileage, B5=Mileage > 3) In cells C1:C5 the user will TYPE IN the cost of each particular > expense: C1=$58.50, C2=$65.75, C3=$15.82, C4=$58.50, C5=$25.00 > > The Problem: > At the bottom of the page, I need all the data entered summarized for job > cost coding purposes. The expense amounts should be summed up based on the > job #, and the cost type and each combination can only appear once. The > summary section cells should result in the following: > > 1) A7=AG, B7=Mileage, C7=$117 > 2) A8=Waterfront, B8=Meals, C8=$65.75 > 3) A9=CN, B9=Supplies, C9=$15.82 > 4) A10=CN, B10=Mileage, C10=25.00 > > Please Help!!! > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
