choosing with a criteria

  • Thread starter Thread starter demolay
  • Start date Start date
D

demolay

i have such a worksheet
column a-----column b------column c
01-01-03-----juve-----------2
02-01-03-----milan----------1
03-01-03-----juve-----------3
....
dont look for logic in this example :) simply, there are some dates i
column a. there is a team name in column b. there is a value in colum
c...
i want to count column c, for a specific name in column b, and in
date range in column a...
dates and names are not in order.
what formula should i use to do this?

such as juve win [2] matches between this date and date date.. and pu
[2] in a cell..
 
Hi

you can use for example
=SUMPRODUCT((A1:A999>=Date_begin)*(A1:A999<=Date_end)*(B1:B999=team_nam
e)*(C1:C999))
Frank
 
Strange,

I only get zero's what am I doing wrong?


Frank Kabel said:
Hi

you can use for example
=SUMPRODUCT((A1:A999>=Date_begin)*(A1:A999<=Date_end)*(B1:B999=team_nam
e)*(C1:C999))
Frank
i have such a worksheet
column a-----column b------column c
01-01-03-----juve-----------2
02-01-03-----milan----------1
03-01-03-----juve-----------3
...
dont look for logic in this example :) simply, there are some dates in
column a. there is a team name in column b. there is a value in column
c...
i want to count column c, for a specific name in column b, and in a
date range in column a...
dates and names are not in order.
what formula should i use to do this?

such as juve win [2] matches between this date and date date.. and put
[2] in a cell...
Click to expand...
Click to expand...
 
Post your exact formula

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



Arnie said:
Strange,

I only get zero's what am I doing wrong?


Frank Kabel said:
Hi

you can use for example
=SUMPRODUCT((A1:A999>=Date_begin)*(A1:A999<=Date_end)*(B1:B999=team_nam
e)*(C1:C999))
Frank
i have such a worksheet
column a-----column b------column c
01-01-03-----juve-----------2
02-01-03-----milan----------1
03-01-03-----juve-----------3
...
dont look for logic in this example :) simply, there are some dates in
column a. there is a team name in column b. there is a value in column
c...
i want to count column c, for a specific name in column b, and in a
date range in column a...
dates and names are not in order.
what formula should i use to do this?

such as juve win [2] matches between this date and date date.. and put
[2] in a cell...
Click to expand...
Click to expand...
Click to expand...
 
Arnie,

Are you testing for date strings? If so, try DATEVALUE("date_begin") etc.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Arnie said:
Strange,

I only get zero's what am I doing wrong?


Frank Kabel said:
Hi

you can use for example
=SUMPRODUCT((A1:A999>=Date_begin)*(A1:A999<=Date_end)*(B1:B999=team_nam
e)*(C1:C999))
Frank
i have such a worksheet
column a-----column b------column c
01-01-03-----juve-----------2
02-01-03-----milan----------1
03-01-03-----juve-----------3
...
dont look for logic in this example :) simply, there are some dates in
column a. there is a team name in column b. there is a value in column
c...
i want to count column c, for a specific name in column b, and in a
date range in column a...
dates and names are not in order.
what formula should i use to do this?

such as juve win [2] matches between this date and date date.. and put
[2] in a cell...
Click to expand...
Click to expand...
Click to expand...
 
Back
Top