Hello,
I have a table of information which is exported out of a CRM programme. In the first column is the users name, the second column is a value which includes a subtotal for the user in the third column there is a letter (either C or L).
I have managed to do a lookup to get the total for the user excluding the subtotal by using this formula. (WBT being the exported worksheet, column C is the value column, column B is their names. The DOC being the sheet the output is then displayed on).
=INDEX(WBT!C:C,SUMPRODUCT(MAX(ROW(WBT!B:B)*(DOC!A9=WBT!B:B))))
I now need to get the same result, only subtotalling the data in column B (in my example attached) based on the data in column C and excluding the subtotal that the CRM software has already calculated.
So, for example, Where Column C has a C, I need the total of these . In this instance, John would be 8, Steve 17 and Mark would be 16.
I have tried adding an IF argument to the above formula but does not like it. Any help gratefully received.
Thanks
Bookmarks