# numerator

1. ### Adding numerator and denominator in same cell

Not sure if this is possible, but I am looking to add both the numerator and denominators and total them in a final cell. It is to track individual phone calls answered vs total phone calls received from a call center. Example. B2- 74/326 (74 answered, 326 total calls) C2- 55/245 D2-...
2. ### Trouble with array formula, countif w/ multiple criteria examples provided

Good Morning, I am attempting to get the follwing to work, not much above novice user but I try, not sure this is even possible, working formula and purpose at bottom of post. Couple of failed attempts, based on help on simpler issues and internet searches. =SUM(COUNTIFS(\$A\$10:\$A\$58...
3. ### Separating Numerator and Denominator of a Fraction formatted Cell into two Separate Cells

I have a cell (A1) with a decimal value of 0.34375 in an adjacent cell (B1) which is equal to (A1) but is formatted as a fraction function with two digits to give a fraction of 11/32. Is there any way I can convert the fraction into two different cells (C1) and (D1) one for the numerator (C1)...
4. ### Extracting Numerator and Denominator to Difference Cells

Hello, I am attempting to extract both the numerator and denominator of a fraction into separate individual cells. For example, a fraction of 209/69, I am seeking your assistance in a formula that can have the 209 and 69 in two separate cells. The fraction varies from one digit in the...
5. ### Looking for a udf to calculate numerator

I have a sheet setup to calculate a naive bayes estimate. I am looking for a udf that can calculate the numerator for me as I have a lot of values to check and this part is manually too time consuming. The udf needs to ignore cells that contain a zero. What I want to be able to do is in cell...
6. ### Automatic Generation of record numbers

I am trying to create a spreadsheet of records that will automatically numerate cases. There will be up to 1,000 records created annually. Our existing process is a =MAX +1 formula, which requires numbers to be entered manually for each case (and is subject to human error) Normally this would...