| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA FOR USE OF CONDITIONAL SUMPRODUCT()
Hello every1!
Can anyone devise me a piece of code to formulate a custom function like: MyRate(Array1,Array2,Array3,Criteria) To work for a function like: =SUMPRODUCT(--(A1:A20="A"),B1:B20,C1:C20)/SUMPRODUCT(--(A1:A20="A"),B1:B20) As: MyRate(A1:A20,B1:B20,C1:C20,"A") All your assistance and expertise shall be highly obliged. Thanx in advance!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up a conditional sumproduct formula (ie. sumifproduct | Excel Worksheet Functions | |||
| Conditional SUMPRODUCT | Excel Discussion (Misc queries) | |||
| Sumproduct conditional | Excel Discussion (Misc queries) | |||
| Sumproduct conditional with dates | Excel Discussion (Misc queries) | |||
| Conditional sumproduct? | New Users to Excel | |||
Linear Mode
