Please help! the formula need to include all the values from sheet BALANTA, column DEBIT OR CREDIT (if code include** then values are from column Debit, if code include *** then values are from column Credit, if code include* then values are from Debit but with red font because need the input of a person/check the total) based on codes from column A from sheet BILANT (201+203+205 etc). These codes must be included in range of column A from Balanta (example: in sheet BALANTA I don't have code 280 like is asked in formula from line 4/ sheet BILANT, but I have 2805 - first 3 characters are 280 and must be taken into consideration. If the calculation (from column A/ sheet BILANT) is include a specific code with 4 characters, then value must be only from that code.
Thank you very much!
Thank you very much!