this is kinda cheating, but I added a helper column and then used this, copied down. sum the results and you get 5.65...
=IF(AND(OR(A1="Jill",B1="Jill"),OR(C1="Floor",C1="Counter")),D1,"")
Edit: I can never get the sumproduct to work lol
this is kinda cheating, but I added a helper column and then used this, copied down. sum the results and you get 5.65...
=IF(AND(OR(A1="Jill",B1="Jill"),OR(C1="Floor",C1="Counter")),D1,"")
Edit: I can never get the sumproduct to work lol
Last edited by FDibbins; 11-10-2012 at 11:52 AM.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks