Happy Days to all - I am looking to get help with using a keyword search as part of a criteria for a SUMIF statement.
I have attached my working copy for you to see.
I would like G2 (I am only using September at this point) to populate the sum of C2:C8, only if D2:D8 contains the word Education. Similar for Government and below with their respective words.
I am not sure if the word was always at the beginning would help, but that is how it would be input in the worksheet.
Thank you for any help!
Bookmarks