My bookkeeper excel whizz has left me unattended!
I have a spreadsheet where I can't get the SUMIF function to work.
Column A = Description
Column B = Cost Centre
Column C = Expense Code
Column D = Debit Value
Column E = Credit Value
Column B and C contain a mixture of different coding.
I want to do a rec and add up the debit and credit values for specific expense codes (column C)and return the debit value. Repeated for the credit values and different expense codes.
Can someone help me with the formula please?