Formula for using integral values in a chart, blank spaces, and looking for overall concordance.

Riny_van_Eekelen 

 Hi Riny,

I hope all is well.  I am so sorry to bother you, but may I please ask you follow-up questions in order to obtain some other data that we need.

--Assuming my chart goes from line 4 to line 10,000, how can I calculate the percentage of “Yes” in the ER/PR concordance for all these 10,000 lines? 

Only the Yes’s and No’s should be in the calculation, and skipping the blank spaces (where no ER/PR testing was performed.)

Most will certainly be “blank or empty” spaces but I wanted to have the flexibility for future testing.

 In the example above, it should be 87.5%.  (7 Yes / 8 Yes + No)

--Finally, if a woman is < 65 years old, how can we calculate the percentage of “ER Negative cases” (where ER % is <1 by definition) from line 4 up to line 10,000 ?   

(ER Positive cases would be when ER > 1 ).  In the example above, it should be  25%  (  2 / 8  ). 

I am having data from line 4 up to line 10,000 to accommodate future testing.  

Thank you kindly Riny.  I really appreciate it.

Sincerely yours, 

Steve