G
Guest
I need the formula for all the amounts that meets certain criteria, but the criteria is not constant, it changes with every row you go down. If the account number in column A corresponds to the acount number of a journal written on another sheet in column E the amount in column G must be added together. This must be done for all the accounts on the first sheet (almost 500, so it won't be economical to type in the corresponding account number in each formule in each row)
This calculation is done in Lotus with the following formula:
@dsum(JnlsA7..J350,"Debit",Code=$A5)
Where Jnls is the sheet where the journals are written, Debit is the label of the column that must be added if criteria are met and Code is the column label in which the account number is typed on the journal-sheet.
Anyone that can help me.
This calculation is done in Lotus with the following formula:
@dsum(JnlsA7..J350,"Debit",Code=$A5)
Where Jnls is the sheet where the journals are written, Debit is the label of the column that must be added if criteria are met and Code is the column label in which the account number is typed on the journal-sheet.
Anyone that can help me.