xlookup to return a sum of return values

[Mstevenson]

Hello. Not sure if xlookup can do this but here is what I'm trying to do:

In the worksheet below I'm trying to use two lookup values (Job and Code) in order to locate all instances of those values and I was hoping to have the sum of those returns (Price) calculated as the final return.

For example, I'm trying to locate all job numbers with the Code "F" and trying to find a formula that can calculate all matching prices as a sum price.

 

[Fluff]

How about

=sumifs(c:c,a:a,e3,b:b,f3)

 

[Mstevenson]

How about

=sumifs(c:c,a:a,e3,b:b,f3)

Oh wow. That works. i was trying to over complicate it. Thank you

 

[Joe4]

Mstevenson,

Please Note: In the future, when marking a post as the solution, please mark the post that contains the solution (not your own post acknowledging that some other post was the solution).
When a post is marked as the solution, it is then shown right underneath the original question so people viewing the question can easily see the question and solution in a single quick glance without having to hunt through all the posts.

I have updated this thread for you.

 

[Fluff]

You're welcome & thanks for the feedback.