xijiangwoo
New Member
- Joined
- Dec 23, 2014
- Messages
- 5
Hello Everyone !
I am a total noob to Excel. I've been slowly teaching myself the past 2 weeks. I have the below formula working with multiple conditions.
=SUMPRODUCT((CompletionDate>=Z15)*(CompletionDate<= AA15)*Engraving)
The CompletionDate is a range column of dates, Z15 is the cell with the earlier date and "AA15" is cell with the later date. If those conditions are met, it will show a total from the "Engraving" range column and display the total in cell "Z25".
I would like to add a criteria to search a column (Person) of 4 different names and display the total from "Mike" (One of the four names).
Am I barking up the wrong tree here?
Any help is grealty appreciated !!!
Xi
I am a total noob to Excel. I've been slowly teaching myself the past 2 weeks. I have the below formula working with multiple conditions.
=SUMPRODUCT((CompletionDate>=Z15)*(CompletionDate<= AA15)*Engraving)
The CompletionDate is a range column of dates, Z15 is the cell with the earlier date and "AA15" is cell with the later date. If those conditions are met, it will show a total from the "Engraving" range column and display the total in cell "Z25".
I would like to add a criteria to search a column (Person) of 4 different names and display the total from "Mike" (One of the four names).
Am I barking up the wrong tree here?
Any help is grealty appreciated !!!
Xi