Hi,
I have this: index(some range,MATCH(1, (A1=F1:F10)*(B1=G1:G10)*(B1=H1:H10).... in A1 is date, in F1&10 are dates. Problem is in G,H,I,J columns. I must search given B1 value inside G1:J10 range. I must look for A1 date in F1&10 range and then SUM that row eg. G4:J4, and that value should be equal B1. I can just use helper column to sum G:J range. But, is there some kind great formula I would appreciate very much. THANKS!
Bookmarks