Replace the semicolon (;) by a plain comma (,):
=SUMPRODUCT(('TRACKING LIST'!C1:C1000="SB")*('TRACKING
LIST'!D1:D1000=1),('TRACKING LIST'!E1:E1000))

I use a french version of Excel, and often forget to replace my ;'s by ,'s

Cheers
--
AP


"Jeff" a écrit dans le message de news:
...
even the single sheet wont work...

"Ardus Petus" wrote:

You previously wrote (quote: "I need to know how many people
ordered water in unit and session.")

Now, if you want the number of bottles, enter:
=SUMPRODUCT((C1:C1000="SB")*(D1:D1000=1);(E1:E1000 ))

Cheers,
--
AP

"Jeff" a écrit dans le message de news:
...
Please read below. It is works, but I am looking for something else.
How I
add up the number of the bottles that ordered in SB and session 1.

Thanks,
Jeff


"Ardus Petus" wrote:
=SUMPRODUCT((C1:C1000="SB")*(D1:D1000=1)*(E1:E1000 <""))

"Jeff" a écrit dans le message de
news:
...
This is not what I wanted.. What you did, you count how many people
in
unit
SB in session 1.. I have to add in there to see how many people
ordered
water.. If nobody ordered water then dont count.... as you see the
column
E
that some people ordered 50 or 75 or 100. I need to know how many
people
ordered water in unit and session.


Thank you.

"Ardus Petus" wrote:

=SUMPRODUCT((C1:C1000="SB")*(D1:D1000=1))

HTH
--
AP


"Jeff" a écrit dans le message de
news:
...
How I use the countif and AND for the below table. I am looking to
count a
number that involved in Unit/Session/Total which has over 500
names.
For
example, In SB, how many people ordered water in session one. It is
applied
to other like in HSB, how many people ordered water in session two.
(If
the
total water ordered is blank means didn't order.)

Key
Column A is Last name
Column B is First name
Column C is Unit
Column D is Session
Column E is Total ordered

Last Name First Name Unit Session TOTAL WATER ORDERED
LastName1 FirstName1 RVG 1
LastName2 FirstName2 SB 1
LastName3 FirstName3 SG B
LastName4 FirstName4 RVG 2
LastName5 FirstName5 SB 1 50
LastName6 FirstName6 SB 1
LastName7 FirstName7 RPG 2
LastName8 FirstName8 HSB 1 75
LastName9 FirstName9 RVG 2 50
LastName10 FirstName10 HSG 2 50
LastName11 FirstName11 RVB 2 50
LastName12 FirstName12 RVB 2
LastName13 FirstName13 HSB 2
LastName14 FirstName14 RVB 1 50
LastName15 FirstName15 RPG 2
LastName16 FirstName16 HSG 1 50
LastName17 FirstName17 HSB 2 100
LastName18 FirstName18 HSB 2
LastName19 FirstName19 SB STAFF 50
LastName20 FirstName20 SRC STAFF 59
LastName21 FirstName21 LS STAFF 58
LastName22 FirstName22 HSB STAFF 50
LastName23 FirstName23 RVG STAFF 75
LastName24 FirstName24 SB STAFF 75
LastName25 FirstName25 TENNIS STAFF 100

Thank you.
Jeff