View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tim Tim is offline
external usenet poster
 
Posts: 408
Default sumif , 2 criteria, text must equal

Hi there,
I need to sum the 'amt' column when the 'code' is equal to 2115 and the
'description' column contains 'gst refund'.
Thanks for anyone's help.
code type description amt
2115 AR-PY 4TH QTR GST REFUND 2,100.00
2115 GL-2 FEB'09 GST DEDUCTED 325.32
2115 GL-2 FEB'09 CASH EXPENSES 5.00
2115 GL-2 4TH GST REFUND quarter 5.66
2115 GL-2 4TH QTR GST-TRAVEL 6.50