=COUNTIFS('S&H NCR List (2)'!$D$3:$D$20000,C14,'S&H NCR List (2)'!O3:Z496,"0",'S&H NCR List (2)'!$A$3:$A$20000,"OPEN")
It end up as #VALUE.
Please help me with this.
=COUNTIFS('S&H NCR List (2)'!$D$3:$D$20000,C14,'S&H NCR List (2)'!O3:Z496,"0",'S&H NCR List (2)'!$A$3:$A$20000,"OPEN")
It end up as #VALUE.
Please help me with this.
Try without the quotes in zero value.
Formula:Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
It still give an #VALUE answer.
I've done many changes...still didnt work. Please help.
this is your problem
'S&H NCR List (2)'!O3:Z496,"0"
you have to have like for like criteria
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Hi Husni!
Try This..
Formula:Please Login or Register to view this content.
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
It's logical...to ignore the suggestions here as you have the same question in another thread.
I am warning you. Don't spent our time posting duplicate threads.
So
unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks