I am trying to use this line of code but I can not get it to work right.
=SUMPRODUCT(A:A,I3,E:E,"Training",H:H)
I have upload a demo of the spreadsheet if you need it the cells are in yellow.
https://www.dropbox.com/s/zlr3sn115czk2i5/demo.xls
=SUMPRODUCT(A:A,I3,E:E,"Training",H:H)
I have upload a demo of the spreadsheet if you need it the cells are in yellow.
https://www.dropbox.com/s/zlr3sn115czk2i5/demo.xls