Dear Friends,
I create a data to get average data. data need match name of supplier and month.
I have attached the data details
Please advise which formula is suitable for column H3,I3, H4, I4.
Thank you in advance for your help.
Regards,
Wie Wie
Dear Friends,
I create a data to get average data. data need match name of supplier and month.
I have attached the data details
Please advise which formula is suitable for column H3,I3, H4, I4.
Thank you in advance for your help.
Regards,
Wie Wie
Try the AVERAGEIF(S) function
Please try at H3 and copy over the table
=AVERAGEIFS($E$3:$E$13,$A$3:$A$13,$G3,$C$3:$C$13,">="&1&H$1,$C$3:$C$13,"<="&EOMONTH(1&H$1,0))
You can put &18 after 1&H$1 if you have other specific year.
=AVERAGEIFS($E$3:$E$13,$A$3:$A$13,$G3,$C$3:$C$13,">="&1&H$1&18,$C$3:$C$13,"<="&EOMONTH(1&H$1&18,0))
Last edited by Bo_Ry; 10-19-2018 at 03:52 AM.
Dear Friends,
That is work. thanks a lot for your help.
Regards,
Wie
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks