Hi everyone,
Now i have another question regarding the INDIRECT formula applied to SUMPRODUCT.
this time to sumproduct of 2 cell when have match (not the match formula) in 2 ranges,
Note:
my main purpose is to keep at all the time the same cell references with formulas that is applied to dynamic range.
(i have to apply INDIRECT in a hundreds of cell that use different formulas)
the actual formula that i'm using work good and this is the task:
Let say that cell E4 is equal 0 and cell M4 equal 6
then the formula look if 0 and 6 are in the same day and sum the times founded in ranges E37 to I137 and range Q37 TO U137
as i said my formula is working good but i have no clue where is supposed to be inserted the INDIRECT function....
I googled in many ways and i think google got tire of me
This is the good formula that need the INDIRECT:
I have tried many of these formulas with not successPlease Login or Register to view this content.
Please Login or Register to view this content.
any help or suggestion is welcome
Thank you so much
Bookmarks