CODEWITHSUNDEEP
excel
Rijnhardt
Rijnhardt

Reputation: 2754

sumifs based on first character in string

I have an Excel Sheet that needs to be summed if it matches a set of criteria.

If it has the same category, and if the section has a specific first character.

Here is what I have - that should theoretically work - but Excel throws an Error that it is not a function.

SUMIFS('In Service Costs'!Q:Q,'In Service Costs'!$A:$A,'Labour GL Summary'!$A$2,LEFT('In Service Costs'!L:L,1),"A")

Upvotes: 0

Views: 1001

Answers (1)

BrakNicku
BrakNicku

Reputation: 5990

You cannot use LEFT inside SUMIFS, but you can use wildcards in criteria:

SUMIFS('In Service Costs'!Q:Q,'In Service Costs'!$A:$A,'Labour GL Summary'!$A$2,'In Service Costs'!L:L,"A*")

Upvotes: 3

Related Questions