Hi I need to retrieve data from sheet 2 with a condition count of >0.
Attached file as you can see in sheet 1 H:K are the data that needed to be filled in with the formula..
See how the numbers are retrieved from sheet 2 in yellow, 1low and 2low and 4 medium.
Please tell me the formula that needs to be filled in sheet 1 H:K
Thank You
is this for microsoft excel or google sheets?
As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.
And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]
HI
this is for google sheet
I really think you should change your forum profile to Google Sheets, otherwise you are going to be asked this almost every time!
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.
Thank You Ali, done
https://prnt.sc/fFzsN69L3aET
awesome!
since your posts count is over 10, you should now be able to post links.
to speed things up (so that helpers dont need to download, upload, then convert files) can you post a link to a sample file, with Editor access enabled for Anyone with the link
to maintain your own privacy, you may like to use this form from the Google Experts:
https://docs.google.com/forms/d/e/1F...VbWiA/viewform
after you fill in some details, it will send a link to your gmail, and then you can drop sample data into the file that is hosted by Google.
Can I just share google sheet without having must fill in those form ?
as i said.. you MAY LIKE TO.... its up to you.Can I just share google sheet without having must fill in those form ?
to make things easier.. instead of making new files every time you add to your existing project.. why not consider using the same file each time?
anyhow.. moving on.... i would like to give a formula that should work.. but your problem (again!) is that your data is poorly constructed... you have rows that can give duplicate results.
clean up your data! *(hint.. look in sheet 2)
then i will provide a formula.
Hi
I have fixed it, please help me
Last edited by Asdf99; 07-18-2022 at 07:00 AM.
Try with sum ifs ?
in Sheet1!H3, then dragged down:
Please Login or Register to view this content.
It's good, but not working in my real data, it's said :
Query completed with an empty output.
voiny.png
Last edited by Asdf99; 07-20-2022 at 04:10 AM. Reason: Adding image
You can attach images using the forum's attachment facility - no need for external links.
sure done editing
that image does not match the data in the spreadsheet you have shared.
please put make sure that the data you share is EXACTLY the same structure as your real life spreadsheet.
also, you have many note saying "fill here the formula for xxxx".. but you have not given any manually calculated results OR any explanation of what you expect to be calculated OR how it should be calculated.
how is anyone to guess what is current and what is forecast?
Last edited by janmorris; 07-20-2022 at 07:07 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks