"Katie Wine" wrote:
I'm having trouble uploading my file, if it helps to see it,
please advise how I can provide it for viewing.

Yes, we might need to see it unless we get lucky with a wild-a.s.s guess.

Have tried to upload to a file-sharing website? The following is a list of
some free ones. IMHO, box.net/files is very easy to get started with and to
use. Just remember to click on "Share", copy the URL and post it in a
response here.

Box.Net: http://www.box.net/files
Windows Live Skydrive: http://skydrive.live.com
MediaFi http://www.mediafire.com
FileFactory: http://www.filefactory.com
FileSavr: http://www.filesavr.com
FileDropper: http://www.filedropper.com
RapidSha http://www.rapidshare.com

Katie Wine wrote:
=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.

The syntax looks okay off-hand. A common cause of such problems is: the
date in P2:P600 is text, not numeric. What does =TYPE(P2) return? Well,
choose a cell in column P that matches your criteria.

Of course, another possibility is: AL2:AL600 and Q2:Q600 do not actually
match the criteria. So many possible ways that can happen. Leading and
trailing spaces or non-breaking spaces (HTML &nbsp). That's why we might
need to see the file.