Hi i need to help with little problem:
i use formula sumifs , where are any ranges in parts of criteria, but i have one criterium(condition) where i wolud like to search in date cells, form this cells i need exlude year and this compare with number in criteria.
is it able ?
Last edited by mmestan; 12-29-2015 at 05:18 PM.
You could use this formula in O3:
=SUMPRODUCT(E2:E8,--(YEAR(A2:A8)=N1))
which will sum the cells in column E where the year in column A is the same as given in cell N1.
Hope this helps.
Pete
thanks ... sumproduct is for me very helpfull
You're welcome - thanks for feeding back.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks