Please can you help me on how to get the total amount for each corresponding weeks. I have been looking for various options or formulas to use but as I go along it confuses me so much.
As you can see on the attached working sheet, what I am trying to achieve is on how to get the total value made by ‘pb ‘ on a particular number of week, total requited £ and accepted £.
Please can you help me on how to get the total amount for each corresponding weeks. I have been looking for various options or formulas to use but as I go along it confuses me so much.
As you can see on the attached working sheet, what I am trying to achieve is on how to get the total value made by ‘pb ‘ on a particular number of week, total requited £ and accepted £.
SUMIF will do this
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Do you mean?
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.
Hi
Cell P5
=SUMPRODUCT(($B$5:$B$60=$N$5)*($D$5:$D$60=$O$5),$E$5:$E$60)
Do the same in Re-Quotation and Final Quote??
regard
micope21
To help you by my post? it would be nice to click onto say "Thank you".
If you are happy with a solution to your problem?
Click Thread Tools above your first post,
select "Mark your thread as Solved".
for quoted use
=SUMIFS(E:E,B:B,N5,D:D,O5)
Not sure what columns you need for the other cells
But you should be able to work out the SUMIFS() criteria
I assume you want to use the weeknumber for re-quoted and for accepted
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Pls take some minutes and read forum rules.
This is a duplicate post and as such does not comply with Rule 5 of our forum rules.
As in both(same) threads there are some replies, i'll merge these 2 threads.
I assume this is what you'll need for the other two cells but you'll have to confirm:
Cell Q5:
Formula:Please Login or Register to view this content.
Cell R5:
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks