CODEWITHSUNDEEP
excelgoogle-sheetsexcel-formulaspreadsheet
JGrayo
JGrayo

Reputation: 3

Summing data in excel from offset cells

Dataset: enter image description here

Results:
enter image description here

Essentially what I am trying to do is come up with a formula that takes the occurrence of a name and sums the total "winnings" associated with that name. Input dataset and ideal output in attached images.

Upvotes: 0

Views: 49

Answers (1)

Harun24hr
Harun24hr

Reputation: 36870

Try below formula-

=SUM(IFERROR(--($B$2:$I$3=B6)*($C$2:$J$3),0))

In case of older version you may need array entry means confirm formula with CTRL+SHIFT+ENTER.

For google-sheet try-

=ArrayFormula(SUM(IFERROR(--($B$2:$I$3=B6)*($C$2:$J$3),0)))

enter image description here

Upvotes: 1

Related Questions