Forum Discussion
SUMIFS Help
Hello, I am in need of some formula help. In the below google doc, under the “cappers tab” you’ll see I have two names in column G and months in I:P. https://docs.google.com/spreadsheets/d/1eLV6O...
More reliable way if you re-structure source data into structured table removing merged cells, after that PivotTable could do the job.
With current layout you may add helper column in Bets with month names (column W in attached) and when in cappers that could be like
=SUMIFS(
Bets!$AB$11:$AB$5000,
Bets!$G$11:$G$5000, $A3,
Bets!$W$11:$W$5000, B$1
)Please check in attached.