Doubt in sum function...

Hello everyone,

I have a doubt on my Excel file related with a sum function, but the function has as criteria the date. See in imagem below:

gPTT7.png


So, I want a simple think, sum the values on H column (Ganhos) but only the specific month.

Example, August has 5 entries so I only want the sum of theses values... And for the others months is the same.


Is easy, but I could not understand how do it.


Sorry if I kicked some word in English.

:|

Thank you oeldere for your fast response, but what vandan_tanna wrote works perfectly!!!

Originally Posted by vandan_tanna

assuming your data is in column A1:A6 and C1:C6 then

=SUMPRODUCT(N(MONTH(A1:A6)=8),C1:C6)

will give you sum for august. Adjust range to fit your data.

Is this what you are looking for?

Like I wrote, works like I wanted.

Thank you!

Originally Posted by oeldere

You can also use pivot table, to solve your problem.

Yes I can but for my problem is a little complicated

Thanks anyway