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 cannot 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
=SUMIFS(Master!$P$2:$P$600, Master!$AL$2:$AL$600, B5,
It returns a count of 0, though for this cell it should return a count
I am having trouble uploading my file, if it helps to see it, please
advise how I can provide it for viewing.
Thanks to advise,