Forum Discussion
How can I correlate multiple collumns/rows, which share the same value, in two different sheets?
The title doesn't explain it all so let me expand a bit. I have a database with multiple sheets. All sheets have the same patients, but different information about them, listed as 1 and 0. In the f...
Hello,
on the assumption that there is a one-to-one relationship, i.e. cause X can only result in one symptom, the one in column C, you can create four formulas
High white blood cells total : 83
=Sum('Biologic Preoperator'!C:C)
Cause x(inguinal hernia) has : 23
=Sum('Cauza ocluziei'!E:E)
Cause y has : 2
=Sum('Cauza ocluziei'!F:F) -- Adjust to the correct column
Cause z has : 14 etc
=Sum('Cauza ocluziei'!G:G) -- Adjust to the correct column