Copying SUMIFS formulas I have a spreadsheet that has the following information

Question

Copying SUMIFS formulas

I have a spreadsheet that has the following information in columns A, B and C

I am trying to use the following sumifs formula in column C

=SUMIFS($H$8:$H$654,$A$8:$A$654,"=Smith, John I",$B$8:$B$654,"=DF-Corporate Borrowings - Other")

I need to change the text fields in the formula each time column B changes and then each time column A and column B change to a new employee and area of practice.

When i copy the formula, i have to manually type in the text fields each time. Instead of manually typing in either field, i tried to reference a cell that had that information but it does not work.

Any suggestions on hoow i might make this process simpler for me?

Thanks!!!!

Smith, John DF-Corporate Borrowings - M&A 749 Smith, John DF-Corporate Borrowings - Other 35,467 Smith, John EMP-Contract Work Advice 1,128 Smith, John IM-Investment Advisory Regulation & Compliance 1,071 Smith, John LIT-General Counsel Role 153,407 Jones, Rich BAN-Adversary Proceedings 349 Jones, Rich BAN-Creditor or Interested Party Representation 9,383 Jones, Rich BAN-Retention/Fee Representation 2,161 Jones, Rich DF-Corporate Borrowings - Other 3,722 Jones, Rich IM-Broker-Dealers Regulations Compliance 4,804 Cleaver, Ron COR-Contract Work 415 Cleaver, Ron IM-Broker-Dealers Regulations Compliance 228 Cleaver, Ron IM-Contract Work & Ongoing Representation 19,201 Cleaver, Ron IM-Fund Formationn 4,202

Explanation / Answer

Hi,

Try it like thiss

=SUMIFS($H$8:$H$654,$$A$8:$A$654,B2,$B$8:$B$654,C2)

Where

B2 = Cleaver, Ron

c2 = IM-Contract Work & Ongoing Representtation

Or any other combination you're looking forr.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.