-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
I need help with match and index!!!!!!
- Thread starter masterx7
- Start date
sum if wont work this time.
posting the source table and the formula table. it's in different language so ignore it.
if you want I can send you the file.
Upvote
0
etaf
Well-known Member
- Joined
- Oct 24, 2012
- Messages
- 8,314
- Office Version
- 365
- Platform
- MacOS
it looks like you are using merged cells - so not the same as your orginal example image
not sure how best to therefor SUM with merged images
what version of excel are you using ?? - would you provide that in your profile
Note: Images are difficult to see , and also requires that I input all the data myself, which means I may make an error, which is very time consuming, and from my point of view less likely to get a response, if a complicated spreadsheet. Plus we cannot see any of the formulas used.
Therefore -
A SMALL sample spreadsheet, around 10-20 rows, would help a lot here, with all sensitive data removed, and expected results mocked up and manually entered, with a few notes of explanation.
This will possibly enable a quicker and more accurate solution for you.
MrExcel has a tool called “XL2BB” that lets you post samples of your data and will allow us to copy/paste your sample data into our Excel spreadsheets, saving a lot of time.
www.mrexcel.com
You can also test to see if it works ok, in the "Test Here" forum.
www.mrexcel.com
OR if you cannot get XL2BB to work, or have restrictions on your PC
then put the sample spreadsheet onto a share
I only tend to goto OneDrive, Dropbox or google docs , as I'm never certain of other random share sites and possible virus.
Please make sure you have a representative data sample and also that the data has been desensitised, remember this site is open to anyone with internet access to see - so any sensitive / personal data should be removed
Make sure you set any share or google to share to everyone
not sure how best to therefor SUM with merged images
what version of excel are you using ?? - would you provide that in your profile
Note: Images are difficult to see , and also requires that I input all the data myself, which means I may make an error, which is very time consuming, and from my point of view less likely to get a response, if a complicated spreadsheet. Plus we cannot see any of the formulas used.
Therefore -
A SMALL sample spreadsheet, around 10-20 rows, would help a lot here, with all sensitive data removed, and expected results mocked up and manually entered, with a few notes of explanation.
This will possibly enable a quicker and more accurate solution for you.
MrExcel has a tool called “XL2BB” that lets you post samples of your data and will allow us to copy/paste your sample data into our Excel spreadsheets, saving a lot of time.
XL2BB - Excel Range to BBCode
Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...
You can also test to see if it works ok, in the "Test Here" forum.
Test Here
Use this forum to test your signature, learn bbcode, smilies, XL2BB, etc. Threads in this forum are automatically deleted after no replies for seven (7) days
OR if you cannot get XL2BB to work, or have restrictions on your PC
then put the sample spreadsheet onto a share
I only tend to goto OneDrive, Dropbox or google docs , as I'm never certain of other random share sites and possible virus.
Please make sure you have a representative data sample and also that the data has been desensitised, remember this site is open to anyone with internet access to see - so any sensitive / personal data should be removed
Make sure you set any share or google to share to everyone
Upvote
0
thank you very much for the help.it looks like you are using merged cells - so not the same as your orginal example image
not sure how best to therefor SUM with merged images
what version of excel are you using ?? - would you provide that in your profile
Note: Images are difficult to see , and also requires that I input all the data myself, which means I may make an error, which is very time consuming, and from my point of view less likely to get a response, if a complicated spreadsheet. Plus we cannot see any of the formulas used.
Therefore -
A SMALL sample spreadsheet, around 10-20 rows, would help a lot here, with all sensitive data removed, and expected results mocked up and manually entered, with a few notes of explanation.
This will possibly enable a quicker and more accurate solution for you.
MrExcel has a tool called “XL2BB” that lets you post samples of your data and will allow us to copy/paste your sample data into our Excel spreadsheets, saving a lot of time.
XL2BB - Excel Range to BBCode
Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...
You can also test to see if it works ok, in the "Test Here" forum.
Test Here
Use this forum to test your signature, learn bbcode, smilies, XL2BB, etc. Threads in this forum are automatically deleted after no replies for seven (7) days
OR if you cannot get XL2BB to work, or have restrictions on your PC
then put the sample spreadsheet onto a share
I only tend to goto OneDrive, Dropbox or google docs , as I'm never certain of other random share sites and possible virus.
Please make sure you have a representative data sample and also that the data has been desensitised, remember this site is open to anyone with internet access to see - so any sensitive / personal data should be removed
Make sure you set any share or google to share to everyone
formula should be on the yellow cell.
I've marked the 3 criteria's matched by their color so you'll know what to compare in the two sheets.
thanks.
8. Secure Managment Report.xlsm
תכנון רבעון 1,רבעון 1,רבעון 1,רבעון 1,רבעון 1,רבעון 1,רבעון 1,רבעון 1,רבעון 1,רבעון 1,רבעון 1,רבעון 1,רבעון 1,רבעון 1,רבעון 1 ינואר,ינואר,ינואר,ינואר,ינואר,פברואר,פברואר,פברואר,פברואר,פברואר,מרץ,מרץ,מרץ,מרץ,מרץ,אפריל,אפריל,אפריל ינואר,פברואר,מרץ,אפריל לידים גולמי,לידים גולמי,לידים גולמי,לידים ג...
Upvote
0
etaf
Well-known Member
- Joined
- Oct 24, 2012
- Messages
- 8,314
- Office Version
- 365
- Platform
- MacOS
sorry , i'm not sure how to do what you after - with the example and with merged cells
hopefully other members will be able to help
BUT
to assist others you do need to answer
hopefully other members will be able to help
BUT
to assist others you do need to answer
as later versions of excel have a lot more functions
Upvote
0
office 365. forget the merged cells. put the value on a regular cell.
Upvote
0
etaf
Well-known Member
- Joined
- Oct 24, 2012
- Messages
- 8,314
- Office Version
- 365
- Platform
- MacOS
its not the result thats the issue - its the data that has merged cells and so sumifs() i posted does not work, and, as i say, not sure how to resolve that
as mentioned would you add the version 365 to your profile - so its always on your name and people know what functions can be applied
as mentioned would you add the version 365 to your profile - so its always on your name and people know what functions can be applied
Upvote
0
