Need help! Using the INDIRECT function within a SUMIF formula

**Kshari** · 04-02-2014, 06:48 PM

I've used INDIRECT for simple things before but I cant seem to type the correct formula for this to work (I'm an amateur and trying to change an old worksheet made by someone else).

My problem is that I have this formula in cell B1: =SUMIF(C33:P33, "Amy", C37:P37)+SUMIF(C38:P38, "Amy", C41:P41) and I am trying to replace the word Amy inside the quotations to whatever word is in cell A1

If I can do this it will solve a lot of time when I make new entries into column A instead of changing the formula by hand each time in column B

**Tony Valko** · 04-02-2014, 06:53 PM

Just replace "Amy" with the cell reference:

=SUMIF(C33:P33,A1,C37:P37)+SUMIF(C38:P38,A1,C41:P41)

**Kshari** · 04-02-2014, 07:18 PM

Wow, that worked, I didn't think the SUMIF would work properly so I didn't even try it, thank you!

You are way smarter than the person who made this sheet originally. This also solved my sorting dilemma, thanks for that also!

**Tony Valko** · 04-02-2014, 07:27 PM

You're welcome. Thanks for the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.