Hi there,
I was wandering if it is possible to do a SUMIF formula...based on 2 values and if the first few characters of a cell are xxx?
So for example, in the example spreadsheet...
I want the sum of column F if the value of C = Natural Person and the first 3 characters of cell A start with ISA
I then want the same but C = Natural Person and the first 2 characters of cell A start with LD
For the Legal Entity, I am presuming I can just use one SUMIF?
I hope this is clear, but if not please do not hesitate to email.
Thankyou so much
Bookmarks