Hi all,
I was wondering whether someone can help me with the below.
Basically as one can see from the attached I have two columns: Column A is made up of 'nominal codes' and Column B is made up of 'Amounts'
I would like to make a formula which would sum all the amounts in column B, however, only those amounts which have a nominal code which starts with a '5', '6', '7', '8', '9'
Thanks a lot, appreciate your kind help!
Keibri
Bookmarks