Please help.....
Please help.....
~Sachin Attri~
Perhaps
=(SUMPRODUCT((A2:A11=D17)*(C2:C11))-SUMPRODUCT((A2:A11=D17)*(B2:B11)))/COUNTIF(A2:A11,D17)
I don't understand which is the expected result for percentage...
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 Sachin,
Do you need 488.89 as weighted average ?
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Hi,
I need weighted average by particular Bands, so whatever Band I input it should give me weighted average for that, as well as Percentage for that specific band only. Later I should be able to get a Total as well but I can do that by taking out the specific criteria once I know the formula.
If my suggested formula does not works for you then as Dilip asked, which is the expected result in your example sheet ...?
Any update Sachin ?
Regards,
DILIPandey
<click on below * if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks