FG

How to sum cells depending on the content of a neighbor cell

Fresh3 days ago
Mar 15, 20269263 views
Confidence Score0%
0%

Problem

I have an Excel document with the following columns; I am trying to find a way of summarising the content in the following way; So far the only way I have been able to achieve this is to filter the list by each reference number (manually) and then add a simple SUM formula to the bottom of the list …

Error Output

Date      |   Reference    |    Amount
23/01/11  |   111111111    |    £20.00
25/09/11  |   222222222    |    £30.00
11/11/11  |   111111111    |    …

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: How to sum cells depending on the content of a neighbor cell

Low Risk

SUMIFS Here is an example formula: And the answer is correct: Of course, you will need to adjust the ranges and criteria to fit your needs. I was able to get the "highlight ref numbers over X amount "collectively"" to work for ONE reference number u…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment