79542675

Date: 2025-03-29 01:42:59
Score: 0.5
Natty:
Report link

For the sample shown try:

=B4*SUMPRODUCT((Sheet2!F$4:F$8=A4)*(Sheet2!H$3:J$3=C$2),Sheet2!H$4:J$8)

Assuming that the actual data may be extended through December modify the formula to read:

=B4*SUMPRODUCT((Sheet2!F$4:F$8=A4)*(Sheet2!H$3:S$3=C$2),Sheet2!H$4:S$8)

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Clif