Hello All,
Please in the attached file, I want to calculate monthly actual in the MONTHLY ACTUAL column of the sheet named "ANALYSIS" from the populated sheet named "REGISTRATION". I've tried using a combination of COUNTIF and TEXT functions but I'm not getting the desired result. What did I get wrong? Check my formular in the attached.
Regards.
Last edited by [email protected]; 05-19-2017 at 06:23 AM.
Try
C4Formula:
Please Login or Register to view this content.
Drag down!!
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Hello ,
Thanks for your reply. The formula you suggested worked well until I expanded the range to 25000 cells. The result is not correct when the range is expanded. Please check the attached.
Regard
Try
=SUMPRODUCT(--(TEXT('ZONE PINS PERFORMANCE DETAILS'!$D$5:$D$25000,"mmm")=Sheet1!A4)*('ZONE PINS PERFORMANCE DETAILS'!$D$5:$D$25000<>""))
Please give specific details.PHP Code:The result is not correct when the range is expanded.
Secondly, from "May" to "Dec" no data in sheet "ZONE PINS PERFORMANCE DETAILS"
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Or:
=SUMPRODUCT(--(TEXT('ZONE PINS PERFORMANCE DETAILS'!$D$5:$D$25000,"mmmyyyy")=A4&2017))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks