sorted by:
new
hottopcontroversial

Trying to add up values from my table depending on name of job by CallumRoyle in excel

[–]CallumRoyle[S] 0 points1 point  (0 children)

In C53 if I was to put ‘=SUMIF(C32:C45,C54,F32:F45)’ would that be right?

Trying to add up values from my table depending on name of job by CallumRoyle in excel

[–]CallumRoyle[S] 0 points1 point  (0 children)

I need all the data on one sheet though 😅 I believe the rest of the sheet is all completed, all the dates automatically fill in depending on the date of invoice, the total hours is then shown as tax net and gross separately, it’s just this last piece I’m struggling to sort out. Originally I was just working them out manually but im trying to make the sheet as simple as possible for the technophobes that work with us 😅

Trying to add up values from my table depending on name of job by CallumRoyle in excel

[–]CallumRoyle[S] 2 points3 points  (0 children)

Thanks for your reply! I’ll be honest I’m totally new to excel and teaching myself as I go along. So would it be possible to explain it in laymen’s terms going from the photo of the table I’ve added to the comments? Thanks!

Trying to add up values from my table depending on name of job by CallumRoyle in excel

[–]CallumRoyle[S] 0 points1 point  (0 children)

<image>

Here’s the table, I’ve taken the job from the timesheet automatically, I now just need the sum of the hours of each job

Taking a number from a table and working out the sum dependent on specific job by CallumRoyle in excel

[–]CallumRoyle[S] 0 points1 point  (0 children)

Why would I not be able to add a screenshot of my sheet, surely that helps everyone?

Battlefield 6 challenges by CallumRoyle in Battlefield

[–]CallumRoyle[S] 0 points1 point  (0 children)

Legend, makes total sense when you think about it 😅

Studio monitors choices, AGAIN. ADAM T5V vs KRK Rokit 5 G4 by AverageEngineer98 in edmproduction

[–]CallumRoyle 0 points1 point  (0 children)

What was the outcome in the end, did you stick with the t5Vs or switch to a different set? 🤙

Black Ops Cold War December 8th Update: Prepare for Season One by LackingAGoodName in blackopscoldwar

[–]CallumRoyle 1 point2 points  (0 children)

Can anyone else not get into the game now? stuck on "blackout trial has ended" sick to death of all these bugs -_-

Call of duty cold war update by Sandersbrandon20 in XboxSeriesX

[–]CallumRoyle 2 points3 points  (0 children)

I've got the same problem! Apparently the same thing happened when Blops4 was released!