Hello, I have a sheet prepared that I am trying to make a counter of how many of Item 1 and Item 2 were sold for each month. My model codes are lister on the 'counter!' sheet on B$2:V$2. I have written outbut all I get is a #VALUE code. Thanks in advance.Formula:
Please Login or Register to view this content.
match countifs.xls
i would use a pivot table and then it will produce the results as required and also can be updated easily
so I have added a new column for Year and Month into the data
set the data as a table - so when you add new information it will be available to the pivot table using a refresh on the pivot table
and then using the pivot table
I have months in the rows
and then item1 and item 2 shown for each product across the columns
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
B3=
This might help :D
Please Login or Register to view this content.
Edit, so you can just drag the formula to end of your criteria.
Last edited by wenqq3; 07-11-2013 at 03:10 AM.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
hi jakeisbill. if you want formulas instead, try this in B3 & copy down & across:
=SUMPRODUCT((TEXT(data!$A$2:$A$4124,"yyyymm")=TEXT($A3,"yyyymm"))*(((data!$B$2:$B$4124=B$2)+(data!$C$2:$C$4124=B$2))>0))
The above assumes item number in the same row as 1 count. the below formula takes it as 2 counts
=SUMPRODUCT((TEXT(data!$A$2:$A$4124,"yyyymm")=TEXT($A3,"yyyymm"))*((data!$B$2:$C$4124=B$2)))
Last edited by benishiryo; 07-11-2013 at 03:20 AM.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks