modification of formula as i get another problem.

Flora Edwards
Flora Edwards used Ask the Experts™
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial