Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Programming > how i use countif and AND?
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 921
Default how i use countif and AND?
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 didnt 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

Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 718
Default how i use countif and AND?
=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



Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 921
Default how i use countif and AND?
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




Reply With QuoteReply With Quote
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 718
Default how i use countif and AND?
=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






Reply With QuoteReply With Quote
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 921
Default how i use countif and AND?
It won't work... I dont know if you understand what I wanted... Can you
explain to me what you did with this equation?

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







Reply With QuoteReply With Quote
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 718
Default how i use countif and AND?
I count the rows where col C = "SB" and col D = 1 and col E is not blank

"Jeff" a écrit dans le message de news:
...
It won't work... I dont know if you understand what I wanted... Can you
explain to me what you did with this equation?

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









Reply With QuoteReply With Quote
  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 921
Default how i use countif and AND?
It is working this time. I figure it out why it didnt work before because
some of the column were copy from another sheet.. Can you explain to me why
you use this function because I dont understand this function. Like why you
use SUMPRODUCT and use "*"

Thank you.
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







Reply With QuoteReply With Quote
  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 718
Default how i use countif and AND?
The boolean conditions (TRUE/FALSE) are converted to 0/1 , then multiplied.
If all conditions are TRUE (1), the result is 1
Then SUMPRODUCT adds these results for all rows in the range., giving a
count.

HTH
--
AP

"Jeff" a écrit dans le message de news:
...
It is working this time. I figure it out why it didnt work before because
some of the column were copy from another sheet.. Can you explain to me
why
you use this function because I dont understand this function. Like why
you
use SUMPRODUCT and use "*"

Thank you.
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









Reply With QuoteReply With Quote
  #9   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 921
Default how i use countif and AND?
One more thing, Sorry.... what is the function that use SB and 1 and B.. I
tried =SUMPRODUCT((C1:C1000="SB")*(D1:D1000=1)*(D1:D1000 ="B") and it wont
work.

Thanks.

"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




Reply With QuoteReply With Quote
  #10   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 921
Default how i use countif and AND?
Sorry.. One more thing.. How I copy the number in another sheet where keep
stored the total number of bottles give out daily in units/session.. I dont
means the totel of WHOLE number in one month.

Thanks,
Jeff

"Jeff" wrote:

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 didnt 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

Reply With QuoteReply With Quote
  #11   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 921
Default how i use countif and AND?
never mind..... My brain is sleeping!!!

Thanks.

"Jeff" wrote:

Sorry.. One more thing.. How I copy the number in another sheet where keep
stored the total number of bottles give out daily in units/session.. I dont
means the totel of WHOLE number in one month.

Thanks,
Jeff

"Jeff" wrote:

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 didnt 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

Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Hybrid Mode Hybrid Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
CountIf - mid() Bongard Excel Discussion (Misc queries) 4 March 18th 09 02:39 PM
How do I use a countif function according to two other countif fu. Kirsty Excel Worksheet Functions 2 February 20th 06 11:44 AM
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") sctroy Excel Discussion (Misc queries) 2 September 25th 05 04:13 AM
COUNTIF or not to COUNTIF on a range in another sheet Ellie Excel Worksheet Functions 4 September 15th 05 10:06 PM
COUNTIF in one colum then COUNTIF in another...??? JonnieP Excel Worksheet Functions 3 February 22nd 05 02:55 PM


All times are GMT +1. The time now is 11:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement