Main Page 
PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Discussion
Countif with two different conditions
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Discussion
Countif with two different conditions
 |
Countif with two different conditions |
|
|
Thread Tools | Rate Thread |
14-05-2006, 06:52 AM
|
#1 |
|
Guest
Posts: n/a
|
Countif with two different conditions
Hello,
I have a table like below displayed. What I want is to count the no. of "GIN'S" for any particular date say for the date of "14/05/2006" / for the month of "05/2006". The answer would have been 6/10. GIN Nos. DATE ITEM QTY DATE STMP MONTH GR702430 14/05/06 ATM0541 54 14/05/2006 08:03:46 AM 05/2006 GR702430 14/05/06 MTM1044 54 14/05/2006 08:03:46 AM 05/2006 GR702431 14/05/06 PTM0748 39 14/05/2006 08:07:13 AM 05/2006 GR702432 14/05/06 ATM0093 78 14/05/2006 08:12:06 AM 05/2006 GR702432 14/05/06 MTM0161 144 14/05/2006 08:12:06 AM 05/2006 GR702433 14/05/06 MTM1050 12 14/05/2006 08:14:39 AM 05/2006 GR702434 14/05/06 ATM0541 54 14/05/2006 08:51:42 AM 05/2006 GR702434 14/05/06 ATM0543 54 14/05/2006 08:51:42 AM 05/2006 GR702435 14/05/06 ATM0549 54 14/05/2006 08:54:52 AM 05/2006 GR702435 14/05/06 ATM0556 54 14/05/2006 08:54:52 AM 05/2006 Help in this regard will be highly appreciated. -- Vikram Dhemare |
|
|
14-05-2006, 11:53 AM
|
#2 |
|
Guest
Posts: n/a
|
Re: Countif with two different conditions
=SUMPRODUCT(--(INT(E2:E15)=--"2006-05-14"))
=COUNTIF(H:H,"05/2006") -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Vicky" <Vicky@discussions.microsoft.com> wrote in message news:CE333E97-38FD-4B41-8FFA-325EC0DEDDAC@microsoft.com... > Hello, > I have a table like below displayed. What I want is to count the no. of > "GIN'S" for any particular date say for the date of "14/05/2006" / for the > month of "05/2006". The answer would have been 6/10. > GIN Nos. DATE ITEM QTY DATE STMP MONTH > GR702430 14/05/06 ATM0541 54 14/05/2006 08:03:46 AM 05/2006 > GR702430 14/05/06 MTM1044 54 14/05/2006 08:03:46 AM 05/2006 > GR702431 14/05/06 PTM0748 39 14/05/2006 08:07:13 AM 05/2006 > GR702432 14/05/06 ATM0093 78 14/05/2006 08:12:06 AM 05/2006 > GR702432 14/05/06 MTM0161 144 14/05/2006 08:12:06 AM 05/2006 > GR702433 14/05/06 MTM1050 12 14/05/2006 08:14:39 AM 05/2006 > GR702434 14/05/06 ATM0541 54 14/05/2006 08:51:42 AM 05/2006 > GR702434 14/05/06 ATM0543 54 14/05/2006 08:51:42 AM 05/2006 > GR702435 14/05/06 ATM0549 54 14/05/2006 08:54:52 AM 05/2006 > GR702435 14/05/06 ATM0556 54 14/05/2006 08:54:52 AM 05/2006 > Help in this regard will be highly appreciated. > -- > Vikram Dhemare |
|
|
|
|
| Thread Tools | |
| Rate This Thread | |
|
|
