Forum Discussion
Formula Correction
Hey Everyone, I am trying to apply one formula but it's giving me no results. Can anyone please correct this formula? Here is the formula =SUMIF(CONCATENATE("E:E",MATCH("ABC",A:A,0)),"T90",B4:...
The two ranges in SUMIF should have the same size, Since the sum range B4:B12 has 9 cells, the criteria range should have 9 cells too.
CONCATENATE("E:E",MATCH("ABC",A:A,0)) returns a string such as "E:E11", not a range...
- Hi,
You are right but this is what I am trying to bring.
I have explained the situation in comments can you please check and it would be great if there is you can help.In addition to HansVogelaar , if you work with data model (recommended way) most probably all could be done with DAX measures.
Why don't you add subtotals to the pivot table. You can then use GETPIVOTDATA to obtain the required sum. Something like
=GETPIVOTDATA("Numbers",$A$1,"RowFieldName","87900")
Or use SUMIF or SUMIFS on the source data of the pivottable.
