Hi,
Is it possible to have a formula that will do the below
JOE, 15, No Pay
DAVE, 20, No Pay
JOE, 16, Full Pay
JOE, 18, Full Pay
DAVE, 21, Time Made Up
JOE, 17, TIME MADE UP
Dave's total mins for No Pay
Dave's total mins for Full Pay
Dave's total mins for Time Made Up
Joe's total mins for No Pay
Joe's total mins for Full Pay
Joe's total mins for Time Made Up
I thought a Sumproduct may help =SUMPRODUCT(A:A="JOE")*(C:C="No Pay")*(B:B)
Thanks for the help in advance
Hi
Looks that 2 missed 2 parenthesis.
Formula:
Please Login or Register to view this content.
This gives 15 as result.
Don't use whole columns reference in your formulas-special if these are ARRAYS formulas. Your aplication becomes slow.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Witha an pivot table you can also select the MIN value.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
here is how i'd do it...
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Sorry for the lack of feedback, this one worked for me =SUMPRODUCT((A1:A10="JOE")*(C1:C10="No Pay")*(B1:B10)) with reduced rows instead of full columns
Thanks for the help really appreciate it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks