Formula to count alternate columns given specific value
Example1.xlsx
In the spreadsheet attached, I am try to get a percent and count of values given the detection code associated with it in the adjacent column. If there is a number with no code, it counts as detected. If there is a number with the letter U, it counts as U.
I need to do this for all rows for the spreadsheet. This is a snapshot of a much larger dataset, so I'd like to automate it as much as possible.
R3 copied down:
=SUMPRODUCT((ISNUMBER(C3:O3)*(ISBLANK(D3:P3))))
T3 copied down:
=SUMPRODUCT((ISNUMBER(C3:O3)*(ISTEXT(D3:P3))))
I assume that you can calculate the %s from this...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Extra information needed! I have just seen J, J+ and R. You did not tell us what happens when these exist.
How can I get a count of U, J, J+, and R separately?
For U: =COUNTIFS(D3:P3,"U")
For J: =COUNTIFS(D3:P3,"J")
For J+: =COUNTIFS(D3:P3,"J+")
For R: =COUNTIFS(D3:P3,"R")
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks