One option is to use =SUMPRODUCT(...)
=SUMPRODUCT((A1:A1000="Name")*(D1:D1000="Section No")*(J1:J1000))

Hope it helps
Ola Sandström


Note:
True*True*8=8
True*False*8=0
=SUMPRODUCT(8+0+.....+15)
....and Wildcards shouldn't be any problem