nishrach02
New Member
- Joined
- Nov 1, 2017
- Messages
- 1
I am trying to get the customer spend for a particular product using Sumifs formula :-
=SUMIFS('UK Raw Dump'!$X$2:$X$2627,'UK Raw Dump'!$C$2:$C$2627,'Customer Profile - EMEA Region'!B2,'UK Raw Dump'!$AY$2:$AY$2627,"Evault")
Where Column X is the spend for the month of September, C is customer ID and AY is the product name.
For some reason it is always returning value as 0
=SUMIFS('UK Raw Dump'!$X$2:$X$2627,'UK Raw Dump'!$C$2:$C$2627,'Customer Profile - EMEA Region'!B2,'UK Raw Dump'!$AY$2:$AY$2627,"Evault")
Where Column X is the spend for the month of September, C is customer ID and AY is the product name.
For some reason it is always returning value as 0