Runningeng
New Member
- Joined
- Jan 4, 2018
- Messages
- 2
I have some excel queries that return 11-digit numbers, but since they are part of a query, they come back as text. In my sumifs command, I want to avoid all of the data that has a certain 11-digit number. Thoughts?
SUMIFS(Inputs[Cost],Inputs[Row_Insert_Date],">="&Pivots!$D$3,Inputs[Row_Insert_Date],"<"&Pivots!$D$4,Inputs[11-digit],"<>"&99600000089)
Thanks!
SUMIFS(Inputs[Cost],Inputs[Row_Insert_Date],">="&Pivots!$D$3,Inputs[Row_Insert_Date],"<"&Pivots!$D$4,Inputs[11-digit],"<>"&99600000089)
Thanks!