SUMIFS with multiple criteria in different rows

eldeartho

New Member
Joined
Mar 13, 2019
Messages
3
Hi everyone,

Apologies I seem to be stuck on what I thought would be a simple formula.

I have a large dataset of customers taking flights (one ways in the dataset) and I am trying to calculate how many are 'most likely' round trip flights (matching by customer name then origin to destination from different rows in the dataset)

The data is laid out below whereby Bob and David would each count as 1 roundtrip but i can't get sumif/s to work.

any advice much appreciated.

CustomerDestinationOrigin DatePieces
BobLAXCVG19/03/20181
BobCVGLAX14/03/20181
JackATLLAX14/03/20181
JackATLLAX14/03/20181
JackATLLAX14/03/20181
JackPBILAX14/03/20181
JackPBILAX14/03/20181
MarkPBIATL14/03/20181
MarkLAXJFK14/03/20181
DavidSEAJFK05/03/20181
DavidJFKSEA14/03/20181

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

eldeartho

New Member
Joined
Mar 13, 2019
Messages
3
Excellent! many thanks.

Is there a way to do the same but calculate the number by the customer name:
Bob = 1
Jack = 0
Mark = 0
David = 1
 

Watch MrExcel Video

Forum statistics

Threads
1,109,522
Messages
5,529,329
Members
409,863
Latest member
stacy09
Top