BrdgBldr
asked on
Excel formula to sum figures of a certain calendar year only
how can I sum in cells B31, B32, B33 and B34 the percentages from range B1 to B29 for the calendar year in A31, 32, 33, 34?
Tried with Sumproduct and sumif but not really successfull...
formula-filter-year.xls
Tried with Sumproduct and sumif but not really successfull...
formula-filter-year.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
great. thanks a lot!
http://www.excelexperts.com/Excel-Tips-Introduction-to-Pivot-tables