Is it possible to count two columns from a cell with a concatenated value on another sheet?

[bteddy1]

Hello,

Thank You for your time.

I have a sheet with two columns with number values in each. On a separate sheet I have two more columns on it. One column has concatenated values of the rows from the first sheet. Example of format(no parenthesis): (36 & 6) . The second, I would like to count how many times the concatenated value (36 & 6) appears in the range.

Example:
___ A___B_______________Sheet two___A_________B
1__36__6_______________ 1___36 & 6_____ 812 (would like count)
2__18__22_______________2___18 & 22
3__15__32_______________3___15 & 32
4__12__ 2_______________ 4___12 & 2

Sorry about the underscores, system wouldn't let me use spaces.
How could I do this?
Thank You

 

[etaf]

36 & 6 - would be text so you could use

countif( Sheet2!A:A, "36 & 6")

unless i misunderstand the question
OR

countifs( sheet1!A:A, 36 , sheet1!B:B, 6 )

Note: Images are difficult to see , and also requires that I input all the data myself, which is very time consuming.

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.

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...

www.mrexcel.com

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

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

 

[bteddy1]

Thank You the reply.
countifs( sheet1!A:A, 36 , sheet1!B:B, 6 ) is how I was trying to do it.
But I wanted to count a range "sheet1.A1:A1000" and match the value in the cell on sheet2 "sheet2.A1".

on sheet2 in cell B1 {countconcat] "fake function for example".
=countconcat( sheet1!A1:A1000, A1) & "&" &countconcat(sheet1!B1:B1000, B1)

do I need to change the sheet 2 datatype?
Is there a function that will do this?
Will it need to be done in code?

thanks

 

[etaf]

not following

i think we need an example loaded , as explained in previous post

countifs( sheet1!A:A, 36 , sheet1!B:B, 6 ) is how I was trying to do it.
But I wanted to count a range "sheet1.A1:A1000" and match the value in the cell on sheet2 "sheet2.A1".

=countifs(sheet1!A1:A1000, sheet2!A1)

=countifs(sheet1!A1:A1000, sheet2!A1, Sheet1!B1:B1000, sheet2!B1)

 

[bteddy1]

Sorry, I can't load anything on this computer.
The examples I posted are pretty clear.

Example:
Sheet one Left of | Sheet two right of |
__Sheet One___________Sheet_Two
___ A___B_______|_______________A_________B
1__36__6________|_______ 1___36 & 6_____ 812 =countconcat( sheet1!A1:A1000, A1) & "&" &(sheet1!B1:B1000, B1)
2__18__22_______|________2___18 & 22
3__15__32_______|________3___15 & 32
4__12__ 2________|_______ 4___12 & 2

I wanted to count a range "sheet1.A1:A1000" and "sheet1.B1:B1000" and match the value in the cell on sheet2 "sheet2.A1".

on sheet2 in cell B1 {countconcat] "fake function for example".
Thank You