Hi
I am aware there are some other threads on this - but I have tried the formula suggested in those and they don't seem to work!
I have a spread sheet which lists a customer type in column B - the customer type is numeric - either 1, 2, 3, 4 or 5 and then within the columns F to L there may or may not be a score from 1 - 5 entered.
I want to be able count how many of customer type 1 has placed a score within the range of columns F to L
I had tried
=SUMPRODUCT(--(B7:B37=1),--(F7:L37="1")) not fully understanding sum product in the hope that the formula would only count those 1's within the Range F7:L37 if the number entered within the range B7:B37 was 1.
This doesn't seem to have worked!
Ideally I would use a pivot table but as the scores are spread across several columns the table sprawls out and is difficult to read - I also need to replicate this over a number of worksheets so have found to paste tables of formulae is easier.
Hope you can help!
Thanks
Hutchie
I am aware there are some other threads on this - but I have tried the formula suggested in those and they don't seem to work!
I have a spread sheet which lists a customer type in column B - the customer type is numeric - either 1, 2, 3, 4 or 5 and then within the columns F to L there may or may not be a score from 1 - 5 entered.
I want to be able count how many of customer type 1 has placed a score within the range of columns F to L
I had tried
=SUMPRODUCT(--(B7:B37=1),--(F7:L37="1")) not fully understanding sum product in the hope that the formula would only count those 1's within the Range F7:L37 if the number entered within the range B7:B37 was 1.
This doesn't seem to have worked!
Ideally I would use a pivot table but as the scores are spread across several columns the table sprawls out and is difficult to read - I also need to replicate this over a number of worksheets so have found to paste tables of formulae is easier.
Hope you can help!
Thanks
Hutchie