Forum Discussion
First time posting. Combine cells with the same value
Hi community! That's my first post of Excel! I have a question about using the following values: I have a Spanish Sharepoint list query in Excel. For each row is a user audit in a store in d...
Yeah!! It was found with the true (Verdadero) values, but it's wrong with the other value.
For example: User1 has 27 "VERDADERO" values and 7 "FALSO" values, not 33. For each user, true value is correct.
How is the problem? I used this formula:
=SUMAPRODUCTO((Tabla_Auditoría[Usuario]=[@Usuario])*(Tabla_Auditoría[[Portal]:[Cabecera]]=[@Incidencia]))
I can't tell what the reason is without seeing your sheet. The formula returns the expected results in my sheet as you can see in the screenshot of my last reply. Can you attach a sample workbook without sensitive data or a screenshot without sensitive data which shows the formula, the whole data and the results in your sheet?