CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
GeorgeC
GeorgeC

Reputation: 1037

Sumif value is like a value in Google Sheets

In Google Sheets is it possible to sum values based on if part of the text matches?

Something like =sumif(Road_Data_InfoX_914510!D:D,"FORMATION*",Road_Data_InfoX_914510!G:G) - with this I get #DIV/0!

So in

enter image description here

I want to sum all the lengths where the item type starts with "FORMATION".

Upvotes: 0

Views: 40

Answers (1)

oshliaer
oshliaer

Reputation: 4979

SUMIF can't return #DIV/0!

It should work fine

enter image description here

Upvotes: 1

Related Questions