We help IT Professionals succeed at work.

modification of formula as i get another problem.

Flora Edwards
Flora Edwards asked
on
I had this question after viewing Formula to add values based on the date range..


now some my dates are in this order format. appreciate your help. thanks.
EE2.xlsx
Comment
Watch Question

Top Expert 2016
Commented:
Hi,

pls try
=SUMIFS(B:B,A:A,">="&DATEVALUE("1 "&TRIM(LEFT(E2,4))&" "&RIGHT(E2,2)),A:A,"<="&EOMONTH(DATEVALUE("1 "&TRIM(MID(E2,FIND("-",E2)+2,4))&" "&RIGHT(E2,2)),0))

Open in new window

Flora EdwardsMedicine

Author

Commented:
Perfect!   Thanks very very much indeed.
Flora EdwardsMedicine

Author

Commented:
Rgonzo1971

thanks very much. i cannot express the gratitude by words. i have posted a question for another similar problem.