using conditional sumproduct, trabspose

David Polsangi 0 Reputation points


I have a huge data base and need to sort and filter some resultsimage

I need to calculate " The labour" working hours in multiple tables of ONE SHEET, as above,


Columns G=if the item is included

I= number of labours

J= hours

User's image

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,689 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Jiajing Hua-MFST 7,625 Reputation points Microsoft Vendor

    Hi @David Polsangi

    Please check whether following formula is helpful.


    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.