Forum Discussion
Solved
column-header based data counting
Hi, I have SRC and DST columns, both have DATEs as headers. DTS columns ROWs are unique with specific text to be collected and represented. SCR columns are not in row so there are other col...
Hi, I think you can solve your problem with MATCH() and OFFSET(). I have created an example. I hope you can use it for your task.
You can probably only get a better answer if your problem is described in more detail. Perhaps you would like to upload an example file. Then it will certainly be easier to help you.
Hi, I think you can solve your problem with MATCH() and OFFSET(). I have created an example. I hope you can use it for your task.
You can probably only get a better answer if your problem is described in more detail. Perhaps you would like to upload an example file. Then it will certainly be easier to help you.
- Dear dscheikey,
Here is another, more detailed post, can you open it?
https://answers.microsoft.com/en-us/msoffice/forum/all/excel-vlookup-hlookup-and-countif-alltogether/61cd338f-cb69-48d0-9c52-90af67d256e6
I got another solution as follows:
"COUNTIFS(INDEX(INDIRECT("'"&$A$2&"'!$A$2:$MMM$300"),0,MATCH(W$1,INDIRECT("'"&$A$2&"'!$A$1:$MMM$1"),0)),$E18)"
I will check yours as well.
A really appreciate your hints and support!
Cheers,
Zs
