Hi All, I have tried to read previous answer to similar questions but still just don't get it…. (excel is so much easier in some ways..) So far I have this formula: =COUNTIFS ({Push-In Job requests Ra…
Hi All, I have a column that I want to gather information from on a seperate sheet - I would like to add all the Negative numbers and the Positive number seperately, so I can then determine Lossess ag…
Hi, I am trying to collate the number of project assigned to individuals by using the COUNTIF function: =COUNTIF({Project Dashboard Range 1}, "Colin Alexander") The problem is, that it is picking up a…
Hi, I am trying to set a criteria, which picks information from two seperate columns in the same sheet, Countif {NCR Owner} = "X" and {Source} = "X" Thank you