sumif ...month number db1 = month number db2

[pccamara]

Hi guys
It seems i can't find the solution for this. Can you help me please?
I would like to sum some values with 3 or 4 criterias. One of them, is the date.
Instead of greater or equal than, and smaller or equal than a certain date, would be easier if i could put on the criteria the month number.
I've attach a sample file
Thanks in advance
Best regards
Pedro

[Richard Buttrey]

Hi,

Please Login or Register  to view this content.

will do it.

[Pete_UK]

What's wrong with this in J3:

=SUMIFS($F$4:$F$13,$E$4:$E$13,">="&I3,$E$4:$E$13,"<="&EOMONTH(I3,0))

(you will probably need to change the commas ( , ) to semicolons ( ; ) and translate the function names).

You can't manipulate the criteria ranges with SUMIFS - you would need to use SUMPRODUCT if you specifically wanted to use the month number, but then if you had some dates in a previous year you would have to include a parameter for the year, so you could do it like this:

=SUMPRODUCT(--(TEXT($E$4:$E$13,"mmyy")=TEXT(I3,"mmyy")),$F$4:$F$13)

Hope this helps.

Pete

[pccamara]

PErfect!! Tks a lot

[pccamara]

Beautifull. Tks very much

[Pete_UK]

You're welcome - thanks for the rep.

Pete