LinkBack URL
About LinkBacks
HI following countifs function is working but it's returning wrong value
Googled it , but not sure what went wrong .
Please Login or Register to view this content.
HI following countifs function is working but it's returning wrong value
Googled it , but not sure what went wrong .
Please Login or Register to view this content.
Post a sample file.
Are you sure about this criteria?
=COUNTIFS('DATA SHEET'!Z:Z,B8,'DATA SHEET'!AD:AD,">="&'DATA SHEET'!AB:AB,'DATA SHEET'!AB:AB,">0")
Yes criteria is correct. Value mentioned AD column should be >= AB column & Value in AB should be greater than 0.
I do not find attach file option while replying . How do I do it?
To attach a file click Go Advanced then click the paper clip on the right of the yellow smiley face.
Is it returning a some values or just zero?
Separate the COUNTIFs into three individual COUNTIF (not COUNTIFS), place in three different cells.
This will show if the problem is one of them is producing zero or a combination of the three is at fault.
Last edited by Special-K; 07-08-2016 at 06:24 AM.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
The paperclip icon no longer works, so you should follow this procedure to attach a file:
Click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.
Hope this helps.
Pete
Using that syntax, the highlighted portion needs to refer to a single cell.Originally Posted by mangeshp4
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Oh yes, you're right. I thought it was my PC when this happened recently.The paperclip icon no longer works
Countifs won't be able to do that.Value mentioned AD column should be >= AB column
Try
=SUMPRODUCT(--('DATA SHEET'!Z1:Z1000=B8),--('DATA SHEET'!AD1:AD1000>='DATA SHEET'!AB1:AB1000),--('DATA SHEET'!AB1:AB1000>0))
Notice I added row #s 1 to 1000 to your ranges.
It's best to NOT use entire column references like A:A in sumproduct.
Restrict it to the actual used area of the sheet.
Ohh. countifs is restricted to a particular cells . Thanks for alternate suggestion.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks