Countif on the user desined condition
Closed
saleem
-
Mar 9, 2010 at 12:55 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 13, 2010 at 08:22 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 13, 2010 at 08:22 PM
Related:
- Countif on the user desined condition
- Phpmyadmin access denied for user 'root'@'localhost' - Guide
- T mobile authorized user - Guide
- Available memory less than 15mb condition zero - Guide
- Ubuntu remove password from user - Guide
- If condition in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 9, 2010 at 09:27 AM
Mar 9, 2010 at 09:27 AM
Lets say you data look like this
And in D2 is where you are entering the name, and you want count to be on D3, then in D3 write
=COUNTIF(A:A, D2)
----- A --------- ### B ------- ### C ----------------- ### D 1 ### NAME - ### REMARK ### -------------------- ### 2 ### SALEEM ### 1 ------ ### ENTER THE NAME ### SALEEM 3 ### SALEEM ### 1 ------ ### COUNT ------------ ### 4 ### SALEEM ### 1 ------ ### 5 ### KALEEM ### 1 ------ ### 6 ### KALEEM ### 1 ------ ### 7 ### HALEEM ### 1 ------ ### 8 ### RAHEEM ### 1 ------ ### 9 ### FAHEEM ### 1 ------ ###
And in D2 is where you are entering the name, and you want count to be on D3, then in D3 write
=COUNTIF(A:A, D2)
Mar 9, 2010 at 10:10 PM
I wanted to count number of 1 entred in front of the name not the names, may be the below given will be clear what i want to get the exact result.
COLM A COLM B COLM-C
DATE VALVE NO RESULT
8-Mar-10 123A 1
8-Mar-10 123B 1 Remakrs 1 = pass
8-Mar-10 123C 0 0 = rejected
9-Mar-10 123D 1
9-Mar-10 123E 1
10-Mar-10 123F 1
USER DATA ENTERING AREA
Enter the date to get the count of valve passed on the date
TOTAL COUNT OF THE VALVES PASSED = ?
if the user enters the date the total count should reflect for that particular date. I oblige not furnishing my requriment. I look forward for your co-operation to resolve my problem.
Regards
Saleem
Mar 13, 2010 at 08:22 PM
For count the formula that I gave you would work
If you want sum then try this
Lets say in D3 you are entering the date and in D4 you want sum
A:A is the date column that needs to be compared
D3 is the date that use want to compare
C:C is the column that needs to be added up
=SUMIF(A:A,D3,C:C)