Hi friends,
I want a total of each item annually for selected financial year in cells. Start date: t3 end date: u3 item: v3
I have used the following formula but it’s giving a sum of grocery selected in v3 only for each item. I have provided the required output in column ‘f’ for your reference.
Any help will be highly appreciated.
Please Login or Register to view this content.
Thanking you in anticipation.
Sincerely,
mso3
Hi
Replace your formula with below one
=SUMPRODUCT(((Data!$L$2:$L$5000>=$T$3)*(Data!$L$2:$L$5000<=$U$3)*(Data!$D$2:$D$5000=D5)*Data!$P$2:$P$5000))
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
Hello Naveed,
Perfect! I understood my mistake now.
Thank you and have a nice day.
Sorry. Deleted. Duplicate post.
Last edited by mso3; 05-15-2015 at 03:00 AM.
Glad to help you and thanks for the Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks