using conditional sumproduct, trabspose

Question

Hi

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

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

=IF(M319,SUMPRODUCT(--(A319:A327=TRANSPOSE(Labour_CC))G319:G327J319:J327*I319:I327),0)

Columns G=if the item is included

I= number of labours

J= hours

Answer 1

Hi @David Polsangi

Please check whether following formula is helpful.

=IF(M319,SUMPRODUCT(--(ISNUMBER(MATCH(A319:A327,TRANSPOSE(Labour_CC))))(G319:G327=1),J319:J327I319:I327),0)

---

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.

---