info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Spaces in a formula
28 views
Skip to first unread message
Ross Dennis
Aug 17, 2022, 11:14:57 AM8/17/22
to
I need to put "search exactly" in my formula, which works fine, as per this
=SUMIFS(N:N,J:J,59,AE:AE,"31/07/2022",D:D,"Internal")
However one of the fields I need to report on is "Retail AG" and if I do =SUMIFS(N:N,J:J,59,AE:AE,"31/07/2022",D:D,"Retail AG") it gives me zero, which I am pretty sure is down to the space in the "Retail AG"- how can I make it read this info?
NB- I do not have the master data to change the name of the cell to not include a space.
=SUMIFS(N:N,J:J,59,AE:AE,"31/07/2022",D:D,"Internal")
However one of the fields I need to report on is "Retail AG" and if I do =SUMIFS(N:N,J:J,59,AE:AE,"31/07/2022",D:D,"Retail AG") it gives me zero, which I am pretty sure is down to the space in the "Retail AG"- how can I make it read this info?
NB- I do not have the master data to change the name of the cell to not include a space.
Claus Busch
Aug 17, 2022, 11:54:52 AM8/17/22
to
Hi Ross.
I guess you have leading or trailing spaces in column D.
Try:
=SUMPRODUCT(N:N*(J:J=59)*(AE:AE=DATE(2022,7,31))*(TRIM(D:D)="Retail AG"))
Regards
Claus B.
--
Windows10
Microsoft 365 for business
Try:
=SUMPRODUCT(N:N*(J:J=59)*(AE:AE=DATE(2022,7,31))*(TRIM(D:D)="Retail AG"))
Regards
Claus B.
--
Windows10
Microsoft 365 for business
Ross Dennis
Aug 18, 2022, 3:07:34 AM8/18/22
to
0 new messages