Share via

Excel formula

Lesa Sanders 20 Reputation points
2024-02-13T22:47:17.46+00:00

test.xml I counted all the service codes. But now I need the Duration that was spent on each code. F is service codes. H is duration. if I had 6 165 I need to know how much time (duration) I spent on them. What formula would I use? =if(f2:f200,"165") then count duration

Microsoft 365 and Office | Excel | For business | Windows
0 comments
Answer accepted by question author
  1. Jiajing Hua 18,140 Reputation points Moderator
    2024-02-14T01:28:04.4066667+00:00

    Hi, Please try following formula =SUMIF(F2:F26,"165",H2:H26), it sums the duration of the service code "165".

    enter image description here

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.