# criteria in SUMIFS and exluding value from cells in range

1. ## criteria in SUMIFS and exluding value from cells in range

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 ?

2. ## Re: criteria in SUMIFS and exluding value from cells in range

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

3. ## Re: criteria in SUMIFS and exluding value from cells in range

thanks ... sumproduct is for me very helpfull

4. ## Re: criteria in SUMIFS and exluding value from cells in range

You're welcome - thanks for feeding back.

Pete

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1