Can I Do This With This Formula

[rockyw]

I want to use this formula =SUMIF(Sheet1!D:D, 100012, Sheet1!C:C) to find a item number, then sum the quantity and return the value. I have some item numbers with variables like, 100012, and 100012A, same number it just adds a letter to the back. Can I have this formula look for several numbers,
=SUMIF(Sheet1!D:D, 100012,100012A,100012B, Sheet1!C:C)

Id like to know before I head in the wrong direction. Thanks

 

[ganeshpoojary05]

Try this:

=SUMIF(Sheet1!D:D,100012,Sheet1!C:C)+SUMIF(Sheet1!D:D, 100012A,Sheet1!C:C)+SUMIF(Sheet1!D:D,100012B, Sheet1!C:C)

 

[Benjaminmin]

Could also use a wildcard potentially, i.e. "100012*"

 

[ganeshpoojary05]

You can also try

=SUMIF(Sheet1!D:D,"100012*",Sheet1!C:C)

 

[Benjaminmin]

You can also try

=SUMIF(Sheet1!D:D,"100012*",Sheet1!C:C)

Thats what I meant with my post above

 

[rockyw]

Thanks I will try that, have a good day.

 

[Jonmo1]

You can also do...

=SUM(SUMIF(Sheet1!D:D,{"100012","100012A","100012B"},Sheet1!C:C))