Filter and sum

[fionalofthouse2]

Hi,

I'm not the best at Excel so please explain in dummy format haha.

I have previously achieved the formula I'm looking for but it has accidentally been deleted out and I didn't make a note of how I achieved it ahh.

For context, this is for work. We have a diary of which project / job each member of staff have been on, filled in using the job ref which is usually 4 numbers. We can then pull off this who has worked on the job / how many days have been spent to figure out labour costs.

We also have an overtime sheet on the same document which we fill in using the same job references, employee name and their rate of pay.

We then have a review page where it pulls the figures from the diary for labour, overtime amount, we infill the amount spent on materials from QuickBooks, a percentage gets added for overheads and then it shows us an overall cost of the job.

My problem is with the overtime - I had a formula that filtered the job reference box dependent on what reference I put in a box on the review sheet, and then it added up the amount. Please could someone help me with a formula to do this?

Hope that all makes sense!

thanks

 

[Joe4]

Welcome to the Board!

It is really hard to grasp your question without seeing the data, how it is structured, and your expected results.
Could you post a small example and your expected results?

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[fionalofthouse2]

Hi,

Thanks for getting back to me. I had a lightbulb moment this afternoon and realised it was the COUNTIF formula that i was needing all along.... wayyyyy less complicated than I was making it out to be.

Thanks for taking the time to help me out.

 

[Joe4]

You are welcome.
Glad you were able to figure it out!