Formula to Sum Range with Conditions

[Gemma King]

Hi All

I would like help on a formula. I am new to this but I would like to return a value with the following conditions:

If a cell is not blank (Column M) and another cell equals a certain value (Column H) then I would like a sum value of column B

Please could someone help as I've been pulling my hair out trying to create a formula that works.

Thanks

[Special-K]

Oops! Rule 1

https://www.excelforum.com/forum-rul...rum-rules.html

A moderator will come along and ask you to change the subject of your thread and stop us from answering until it's done.
Change it now so we can answer, though I don't know how to do that and probably don't have access to commands you have sicne you started the thread.

Take a look at what others have chosen as a thread subject.

Also amend your description to indicate what that "certain value" is in H, or youll have to completely understand what the solution given is.
To be honest you'd do better to post some example data with expected results.

[AliGW]

As you are new, I have changed your thread title for you. In future, no generic titles, please - they must be indicative of the problem you need to solve.