Microsoft Excel
--
Questions
--
Followers
Top Experts
Readin text in an if staement
I have a nested If statement that must do a countif if two criterion are met. The first criteria iis that a certain name must be found under the site name column, the second criteria is there must be some text in the error column section. If both comments are met then a count is to be done for each piece of data that meets both criteria. the statement follows
IF(AND(D6:D18="cheyenne",F
Evauation id reviewer Tape-id site name capture date errors
1 m 15 Bryan 3/12/2011 yes
1 m 15 Bryan 3/13/2011 yes
1 m 15 Bryan 3/14/2011
1 m 15 Houston 3/15/2011 yes
1 m 15 Houston 3/16/2011 yes
1 m 15 Houston 3/17/2011 no
1 m 15 Tulsa 3/18/2011 no
1 m 15 Tulsa 3/19/2011 no
1 m 15 Tulsa 3/20/2011 no
1 m 15 Cheyenne 3/21/2011
1 m 15 Cheyenne 3/22/2011 no
1 m 15 Cheyenne 3/23/2011 no
1 m 15 Cheyenne 3/24/2011 no
URS.xlsx
IF(AND(D6:D18="cheyenne",F
Evauation id reviewer Tape-id site name capture date errors
1 m 15 Bryan 3/12/2011 yes
1 m 15 Bryan 3/13/2011 yes
1 m 15 Bryan 3/14/2011
1 m 15 Houston 3/15/2011 yes
1 m 15 Houston 3/16/2011 yes
1 m 15 Houston 3/17/2011 no
1 m 15 Tulsa 3/18/2011 no
1 m 15 Tulsa 3/19/2011 no
1 m 15 Tulsa 3/20/2011 no
1 m 15 Cheyenne 3/21/2011
1 m 15 Cheyenne 3/22/2011 no
1 m 15 Cheyenne 3/23/2011 no
1 m 15 Cheyenne 3/24/2011 no
URS.xlsx
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
You can use the following formula in cell H6 and copy to the right
=COUNTIFS($D$6:$D$18,H$5,$
Do a custom format as follows if you want the 0 values to show as "Fail"
0;;"Fail"
Or use the extended formula
=if(0=COUNTIFS($D$6:$D$18,
Thomas
=COUNTIFS($D$6:$D$18,H$5,$
Do a custom format as follows if you want the 0 values to show as "Fail"
0;;"Fail"
Or use the extended formula
=if(0=COUNTIFS($D$6:$D$18,
Thomas
Thom , can u do the exmple on the attached spreadsheet and show me the fomula where a count is attach it? The criteria is that the ashed for name must be in the site name column and there must be text in the ERRor column. if both criteria are met then do a countif on the site name in the first part of the if statement?
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Microsoft Excel
--
Questions
--
Followers
Top Experts
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.