SUMIF help

  • Thread starter Thread starter Reid
  • Start date Start date
R

Reid

I am using the following formula: SUMIF(X$6:X$215,"A",
K$6:T$215) where column x has a customer grade
(A,B,C,D,F) and columns G through T have dollar amounts
based on how long overdue the invoice is. I am trying to
sum only invoices that are over 30 days old (column K
through T) for all the A rated customers. However the
result of the formula is only adding up the values in
Column K and does not include the adjacent cells L through
T. Any suggestions or fixes to my formula would be
greatly appreciated.

Thanks,
Reid
 
Back
Top