VBA Sumproduct With Multiple Criteria

[hobbiton73]

Hi, I wonder whether someone may be able to help me please.

I'm trying to put together a formula applied via VB which totals one particular column if certain criteria are met.

The line I've put together is as below:

Please Login or Register  to view this content.

The problem I have is that, although no error message is displayed the returned results are incorrect.

The problem seems to be around the final part of the formula here:

Please Login or Register  to view this content.

If I remove either one of these checks, the correct results as displayed, but as soon as I incorporate the two, this incorrectly shows 'zero'.

I just wondered whether someone may be able to look at this and let me know where I'm going wrong.

Many thanks and kind regards

[Bob Phillips]

You are testing for the range to be equal to "Test Advice" AND to "SME", which seems unlikley. You probably need to OR it.

Try this

Please Login or Register  to view this content.

[hobbiton73]

Hi @Bob Phillips, thank you for taking the time to reply to my post and for the solution. It works perfectly!

All the best and kind regards