Creating an array to automatically calculate column F

[kafarrell]

Currently, I have to manually enter the number of bundles in column F. I would like to create an array that would calculate the number of bundles on the data tab in column F to the Totals tab in column F based on column A, B and E (Totals tab) matching the data tab columns B, C and S.

[AlKey]

Hi kafarrell,

Can you at least tell us how you do your calculations so we could understand how you arrived at the results that you have in column F?

[samba_ravi]

=SUMIFS(Data!F$2:F$66,Data!A$2:A$66,$C2,Data!B$2:B$66,$A2,Data!C$2:C$66,$B2,Data!S$2:S$66,$E2)
Try this and copy towards down

[kafarrell]

Thank you... I figured it out! =SUM(IF(Data!B:B='Totals by PL&E SO'!A2,IF(Data!C:C='Totals by PL&E SO'!B2,IF(Data!A:A='Totals by PL&E SO'!C2,IF(Data!S:S='Totals by PL&E SO'!E2,Data!F:F)))))

[samba_ravi]

Thanks for your feedback and adding reputation points