I am trying to sum together groups of numbers in Excel based on groupings. As in the attached example, certain weights are grouped according to the Shop number. Is there a way to use a function to automatically
The formula has taken the sum of numbers which are greater than 2. If we change the criteria in cell C2 from 2 to 5 then the result would be updated automatically. This time formula will calculate sum of the numbers which are greater than 5....
=IF(OR(O2="Positive"),"0",IF(OR(O2="Negative"),"1")) "0" and "1" are text values, not numbers. You should use 0 and 1 instead. HansVogelaar no problem, i have attached a sheet below I have deleted data out of this leaving only the 2 sheets I want to lo...
no problem, i have attached a sheet below I have deleted data out of this leaving only the 2 sheets I want to look up from and the one I want to put info in *link removed* cmckernan93 The formula in ABC!M2 is =IF(OR(O2="Positive"),"0",IF(OR(O2="Negative"...