Help with SUMIFS
 

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

Help with SUMIFS
 

"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.

Help with SUMIFS
 

Hi Katie

That should work.

I would check that the formatting of your customer number in the
Master sheet and the Ship Summary sheet is the same, (ie both text or
both numbers, you can use the =TEXT(cell_reference) or
=NUMBER(cell_reference) to check)

Cheers
Julie

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"..
_______
memory foam mattress | adjustable mattresses | memory pillow