I'm working with bowling hoakie ( i think thats his screen name) and he posed the following question and the answers to his post follow as well.
The problem we are having is that columns a and b are taken from someone elses database and i think there must be hidden spaces before or after the numbers or letters because the formulas aren't working for us.
Can someone help:
The original question follows:
If i have 3 entries with florida and 2 of them are the same que number (#77), i need to get a total of all of the production for the specific que number and Florida.
Que District Production
Number Name Vol
77 Florida 1
201 Golden Gate 8
201 Florida 9
77 S California 4
77 Florida 2
77 Golden Gate 8
In this case it will be 3
Can someone please help me
Thanx
--------------------------------------------------------------------------------
Albert 1
Board Regular
Joined: Feb 23, 2002
Posts: 38 Posted: 2002-06-24 08:16
--------------------------------------------------------------------------------
=SUMPRODUCT((A1:A6=77)*(B1:B6="florida")*(C1:C6))
--------------------------------------------------------------------------------
Brian from Maui
Board Master
Joined: Feb 17, 2002
Posts: 367 Posted: 2002-06-24 08:25
--------------------------------------------------------------------------------
=sumproduct((a1:a6=c1)*(b1:b6=d1))
where C1 houses 77 and D1 houses Florida
--------------------------------------------------------------------------------
Bowlnhokie
Welcome to the Board
Joined: Apr 24, 2002
Posts: 5 Posted: 2002-06-24 09:01
--------------------------------------------------------------------------------
Thanx
--------------------------------------------------------------------------------
The problem we are having is that columns a and b are taken from someone elses database and i think there must be hidden spaces before or after the numbers or letters because the formulas aren't working for us.
Can someone help:
The original question follows:
If i have 3 entries with florida and 2 of them are the same que number (#77), i need to get a total of all of the production for the specific que number and Florida.
Que District Production
Number Name Vol
77 Florida 1
201 Golden Gate 8
201 Florida 9
77 S California 4
77 Florida 2
77 Golden Gate 8
In this case it will be 3
Can someone please help me
Thanx
--------------------------------------------------------------------------------
Albert 1
Board Regular
Joined: Feb 23, 2002
Posts: 38 Posted: 2002-06-24 08:16
--------------------------------------------------------------------------------
=SUMPRODUCT((A1:A6=77)*(B1:B6="florida")*(C1:C6))
--------------------------------------------------------------------------------
Brian from Maui
Board Master
Joined: Feb 17, 2002
Posts: 367 Posted: 2002-06-24 08:25
--------------------------------------------------------------------------------
=sumproduct((a1:a6=c1)*(b1:b6=d1))
where C1 houses 77 and D1 houses Florida
--------------------------------------------------------------------------------
Bowlnhokie
Welcome to the Board
Joined: Apr 24, 2002
Posts: 5 Posted: 2002-06-24 09:01
--------------------------------------------------------------------------------
Thanx
--------------------------------------------------------------------------------