View Single Post
Old 11-21-2019, 02:31 PM   #72
#1 Goaltender
Join Date: May 2009

Hey guys I am having trouble with an excel formula. I am trying to to compile totals on a summary page over 12 sheets (months of year). I know sumif with indirect should be able to do this but I can't wrap my head on the formula.

on Summary Tab I want the sum total in j20 (this is the name searching in b5:35)

on each month tab I need to search for a specific name in b5:b35 and then add the corresponding totals between d5:d35

Each month is named Jan,Feb,Mar etc..
fundmark19 is offline   Reply With Quote