Hello,

My first time using SUMIFS, based on what the function is meant to do, I think this is the function I should be using, but just can't seem to get it to work.

I have data on my Master tab, and attempting to total on my Ship Summary tab. The issue may be that I am not referencing the other tab correctly.

Sum Range: Sum the numbers in column P in the Master tab
The criteria I need is:

1) If the client number in column AL in the Master tab equals the client number in column B in the Ship Summary tab

2) If the text in column Q in the Master tab equals "Bottles"

Currently I have the below formula entered in cell G5 in the Ship Summary tab:
=SUMIFS(Master!$P$2:$P$600, Master!$AL$2:$AL$600, B5, Master!$Q$2:$Q$600, "Bottles")

It returns a count of 0, though for this cell it should return a count of 12.
I'm having trouble uploading my file, if it helps to see it, please advise how I can provide it for viewing.

Thanks to advise,
Katie