I need to sum column "H" if a condition is met in column "A" and column "E". "A" contains names followed by one of theses characters: < > ^. Column "E" is Yes or No. I need the sum of all names followed by <.


Column A: Jane Smith <

Column E: Yes

Column H: 12.00


I have tried this formula or numerous variations of this formula and it returns zero or #value. Can you help?

=SUM(IF('Training Hours'!A4:A2000="*<",IF('Training Hours'!E4:E2000="Yes",'Training Hours'!H4:H2000)))