I need a very simple formula.
See enclosed demo excel doc.
In the green fields in "sheet 1" I need a formula, that calculates the SUM of fields from "sheet 2" where:
- the value (date) in row 5 in "sheet 1" matches the value (date) in row 1 in "sheet 2" (please note that the dates have diff formats, this cannot be changed) AND
- the value in column B in "sheet 1" should match the value in column A in "sheet 2".
so it is some kind of lookup formula.
I am BS in Computer Science,easily manage and work with computer. I work as a freelancer from more than 2 years as a word, excel, power point, copy/paste and many more. being an computer graduate I can handle difficult tasks easily