0

I am currently working on a progress bar. Above or next to the progress bar I would like to display the value of progress made not as a percentage but rather in a format like this:

5/4

This shall illustrate that 4 out of 5 tasks have already been completed.

Since the total number of tasks as well as the number of completed tasks shall be obtained from another sheet with the help of a formula, I am desperately looking for a formula which could perform this kind of job.

Any help would be appreciated a lot! Thanks!

4
  • 1
    Please edit your question to include some example (mock) data (before and after). See Format Text as a Table for a web utility that will help you to create a nice data table you can paste into your question.
    – DavidPostill
    Apr 20, 2016 at 9:20
  • Your question is quite confusing now :S... Why do you tagged it as [progress] and [progress-bar] if it's about formulas? You can use something like: A1 & "/" & A2? Apr 20, 2016 at 9:21
  • =COUNTIF('Worksheet A'!A1:A10,"Category A")&"/"&COUNTIFS('Worksheet A'!A1:A10,"Category A",'Worksheet A'!B1:B10,"Done")
    – Gaijin565
    Apr 20, 2016 at 9:33
  • Just an observation: the universal convention for 4 out of 5 completed is 4/5 rather than 5/4.
    – fixer1234
    Apr 21, 2016 at 1:06

1 Answer 1

0

Use & "/" & in place of "/". Eg : Formula of a cell =B4& "/" &C4 would display <value at B4>/<value at C4>

6
  • Thanks! So would this statement work then? =COUNTIF('Worksheet A'!A1:A10,"Category A")&"/"&COUNTIFS('Worksheet A'!A1:A10,"Category A",'Worksheet A'!B1:B10,"Done")
    – Gaijin565
    Apr 20, 2016 at 9:40
  • Yes. It will give you outputs like 0/0 or 1/0 etc.
    – Ani Menon
    Apr 20, 2016 at 9:46
  • Is it then possible to do some conditional formatting based on these values?
    – Gaijin565
    Apr 20, 2016 at 9:52
  • Yes, Conditional formatting
    – Ani Menon
    Apr 20, 2016 at 9:57
  • But what format would I have to choose for the cell value? Percentage or something else?
    – Gaijin565
    Apr 20, 2016 at 10:00

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .