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..
|