SUMIF help

[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

 

[Peo Sjoblom]

One way

=SUMPRODUCT((X$6:X$215="A")*(K$6:T$215))