Hi There
I have tried SUMIFS, using AND and SUMIF, SUMPRODUCT etc but can't find a tidy way to sum from 1 to 12 columns based on two criteria. Essentially what I have is a 12 months of Profit and Loss data in columns D:O. I then have the Account Code (criteria 1) in Column A and Department...