LinkBack URL
About LinkBacks
Any help much appreciated.
count E18 as 0.5 and K18 as 0.5 (if K18 is not blank) or count E18 as 1 and K18 as 0 (if K18 is blank)
countif formula
Any help much appreciated.
count E18 as 0.5 and K18 as 0.5 (if K18 is not blank) or count E18 as 1 and K18 as 0 (if K18 is blank)
I recommend uploading a small representative sample of your data along with the desired results (which you can enter manually) based on that data.
To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"
Manage attachments doesn't seem to be working, when I click the paperclip the dropdown box is empty
Don't try to use the Paperclip icon, as it doesn't work on this forum.
Use the procedure outlined in Post #2.
Hope this helps.
Pete
Thank you it should be attached now
Last edited by AliGW; 11-05-2018 at 11:33 AM.
Where are the desired results in the sample from post #5?
It should be in cell C8
Last edited by AliGW; 11-05-2018 at 11:33 AM.
Cell C8 is blank.
Post #2 asks for "the desired results (which you can enter manually) based on that data". You have not yet provided this.
Max - please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!
For normal conversational replies, try using the QUICK REPLY box below.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I was using my phone at the time apologies.
I think I'm getting confused here
If E18 is not empty, I18>0, if K18 is empty count 1 but if K18 is not empty count as 0.5 and add 0.5 again if P18>0
These cell references are manual input, C8 should be a table total of these conditions
You need to add expected outcomes manually to your workbook and post again.
I feel like ive came to a dead end
the desired outcome should be in C8 (a table total of the conditions stated) apologies for coming across simple minded
Last edited by max8719; 11-05-2018 at 12:28 PM.
We know it should be in C8... but what is the NUMERICAL VALUE of the answer you expect to see???
17, 156, 132, 555, 222 or what???!!!
Calculate it manually and tell us....
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
ive attached it with desired outcome in column T, can this not be done in a formula and not creating another column for this calculation?
Thanks for your support
Last edited by max8719; 11-05-2018 at 01:00 PM.
Maybe this:
=SUMPRODUCT(0.5*(($I$18:$I$35>0)*($K$18:$K$35<>"")))+SUMPRODUCT(($I$18:$I$35>0)*($K$18:$K$35=""))
I say maybe as C8 says 4.5, whereas the sum of T is 5.5 (which this formula gives). See sheet.
Thanksits 5.5 because I missed out a condition which is A18:A134=A3, how do I adapt the sumproduct formula to include this please
One way:
=SUMPRODUCT(0.5*(($I$18:$I$35>0)*($K$18:$K$35<>"")*($A$18:$A$35=$A$3)))+SUMPRODUCT(($I$18:$I$35>0)*($K$18:$K$35="")*($A$18:$A$35=$A$3))
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
legend, rep heading your way, thanks
Cheers!! Any time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks