Find attached sheet 2 where there is data , need formula on sheet4 on c3 that I will add right
to get the total sales of each person till that date
SAT MON TUE WED THU FRI SAT MON
1 person 1
Find attached sheet 2 where there is data , need formula on sheet4 on c3 that I will add right
to get the total sales of each person till that date
SAT MON TUE WED THU FRI SAT MON
1 person 1
not sure what your getting at but somthing like
=SUM(Sheet2!$C3:C3)
dragged across will give a running total
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
In C3 and copy down and across.
Formula:Please Login or Register to view this content.
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.
Please see attached file
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Yes twiggywales , have added you a reputation
It will help a lot , I need a running since I will add there target per day at running too , to arrive to
performance indicator per day , your answer made my day
Hi
Paste this to c3 cell
=SUMPRODUCT((C$2>=Sheet2!$C$2:$J$2)*(Sheet4!$B3=Sheet2!$B$3:$B$13)*Sheet2!$C$3:$J$13)
Appreciate the help? CLICK *
Thank you ALKEY , FOTIS1991 and AZ-XL
But i choose to go for this one
=SUM(Sheet2!$C3:C3)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks