VBA Sumproduct Match

[hobbiton73]

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

I'm trying to put together a formula through VB which contains a number of criteria which need to be met for the correct result to be displayed.

This is the formula which I've put together so far:

Please Login or Register  to view this content.

The problem I'm having is with this part of the formula:

Please Login or Register  to view this content.

What I'm trying to do is say that the value must equal "Leave". But when I run this, the results include those rows that contain the word "Leave", rather than just those where the cell content is exactly "Leave".

I've tried changing this to say

Please Login or Register  to view this content.

,

Please Login or Register  to view this content.

but unfortunately neither of these work.

I just wondered whether someone could possibly look at this please and let me know where I'm going wrong.

Many thanks and kind regards

[AlphaFrog]

Try this...

*(Task=""Leave""), AFTE)"


Just like the syntax for your RLOB criteria.

[hobbiton73]

Hi @AlphaFrog, thank you very much for taking the time to reply to my post, and for setting me straight. The formula now works perfectly. I must admit to being a little embarrassed at not spotting the obvious!

All the best and kind regards

[AlphaFrog]

You're welcome.

You just had a touch of the tunnel vision. Everybody gets it once in a while.

[hobbiton73]

Thank you for your understanding.

Kind Regards