Dynamic SUMIF?

[Mark McInerney]

Hi Folks,

Is it possible to do a sumif on a dynamic range of data?

e.g. there are sales items in A1:A100, and sales values in the adjoining column B1:B100.

In D1:D10 I want to be able to insert any sales items in these 10 cells, and have a formula that calculates the sales for those 10 sale items in cell D11 - is this possible?

Thanks for taking the time to review - appreciated.

 

[SpillerBD]

I support using proper data sets. Your proposal does not fit that ideal.
See the educator, Mike "Boomerang" Girvin video E-DAB 02
Also, that entire Play list.

 

[ZMyrrh]

I would use =SUM(SUMIF(A1:A100,D1:D10,B1:B100)). Make Sure you use Ctrl + Shift + Enter To Finish The Formula

 

[Fluff]

Another option

=SUM(FILTER(B1:B100,ISNUMBER(MATCH(A1:A100,D1:D10,0)),0))

 

[Fluff]

Make Sure you use Ctrl + Shift + Enter To Finish The Formula

No need to use CSE in 365 or 2021

 

[Mark McInerney]

Hi All,

As usual - this forum is such a great community of people supporting people - Thank you all for taking the time to review my query.

 

[Fluff]

Glad we could help & thanks for the feedback.