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)))
Bookmarks