Nest / Combine 2 Sumproduct Functions from 2 Different Tables

Hi,

Looking to nest or combine the following 2 functions because I'm looking up the same cell content, except within 2 different tables.

=IF(B12="","",SUMPRODUCT(--($B$12:$B$17=X18),--($S$12:$S$17))) and =IF(B22="","",SUMPRODUCT(--($B$22:$B$32=X18),--($S$22:$S$32)))

Right now, these functions works well from a single table but need to combine them. Other function examples are welecomed too.


Thanks

Hi,

Nevermind - I just managed to figure this out by myself by using:

=IF(B12="","",SUMPRODUCT(--($B$12:$B$17=X18),--($S$12:$S$17)))--IF(B22="","",SUMPRODUCT(--($B$22:$B$32=X18),--($S$22:$S$32)))

However, I still welcome other suggestions.

Thans

Hi ben_hensel,

I like your suggestions & both work well too. Why is the '0' needed within the first example?

Hi Everyone,

I would like to add an addition to my original question. Now, I would like to sum between 2 tables & between 2 dates or get a weekly breakdown instead of a cumulative total.

For examples, in cell, F57, I have 08/11 & in, F58, have, 08/27.


Where & how could I add this in into any of the above examples given.

Thanks

Hi,

Does anyone have feedback?