Friends,
I am trying this formula but it does not work. Can someone help me? What i am trying is matching two dates and and two condition to give me the count. Please give me the formula?
I have attached the spreadsheet and what i need is Matching Mar-16 in the raw data and count how many desktop is reimaged and reimaged.
Hi -
You have quite a few issues with your formula/syntax.
First, you are comparing a text date "Jan-2016" to an Excel date value (which is a number) So that won't work.
Next, your search is for "Reimaged" and "NotReimaged" but your whole data set is "Replaced" and "Not Replaced" So that will never be a match.
Finally, I personally don't like hard coding your search criteria (such as "Reimaged" or "Jan-2016") into your formulas. Instead, put those elements into separate cells and reference them from your formulas. That makes changing/editing your search criteria really easy.
Anyway, I corrected all of the above in the attached spreadsheet.
Hope this helps
____________________________________________
If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved
If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.
Pls check attachment
Try
D6=SUMPRODUCT((Table2[Machine Type]='Cover Page'!D$5)*(Table2[Completed]='Cover Page'!$C6)*(Table2[Status]=IF(COLUMNS($D$5:D5)<=2,"Replaced","Not replaced"))) and drag towards the cells
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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks