Monday, October 17, 2016

yogi_Count Number Of Loans For Loan Officers Listed In Cells A2:A4 From Loan Info In Cells A8:E

Google Spreadsheet   Post  #2078
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Oct-17-2016
question by: David Oziel:!topic/docs/GxLUk8-24sg;context-place=forum/docs
How do I add up numbers in a column if a text string in an adjacent column matches?
I have a list of loans that are assigned to different LOAs and I need to add up the total dollars assigned to them. I need to make sure I only add the dollars assigned to the LOA to their total. How do I do that? I am summarizing their numbers at the top of the sheet.