Filter within Filter by dates?

[excelNewbie22]

hi,
if needed i'll provide data sample,
i tried alone, with googling,
first formula:

=SUM(FILTER(C73:C200,D73:D200="abc"))

second one:

=SUM(FILTER(C73:C200,(A73:A200>=7/7/2024)*(A73:A200<=TODAY())))

combined:

=SUM(FILTER(FILTER(C73:C200,(A73:A200>=7/7/2024)*(A73:A200<=TODAY())),D73:D200="abc"))

but it returns error "#Value!"
why?

 

[Fluff]

Because your ranges/array are no longe the same size after the initial filter.
Maybe

=SUM(FILTER(C73:C200,(A73:A200>=7/7/2024)*(A73:A200<=TODAY())*(D73:D200="abc")))

 

[excelNewbie22]

as usual.... thank you fluff!
what does the * represent in excel?
i know it's for multiplication but i don't understand how it fits in

 

[Fluff]

It's the array version of using AND

 

[excelNewbie22]

thanks!

 

[Fluff]

You're welcome & thanks for the feedback.