How to use SUMIFS with the criteria referencing a cell

The formula


does not work unless I actually enter the contents of B8 and C8 into the formula giving


What is the workaround for this in Excel?

Paul BurrowsAsked:
Who is Participating?
Saqib Husain, SyedConnect With a Mentor EngineerCommented:

Paul BurrowsAuthor Commented:
Awesome ... thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.