| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need a productif style function
I want to search a range of cells, say C:C for a value, if that value is
there i want to multiply the corresponding B cell and D cell together then sum up all of the true values. If anyone can help me please let me know. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need a productif style function
Try something like:
=SUMPRODUCT(--(C1:C10="A"),--(B1:B10),--(D1:D10)) Sum the products of B*D when C="A" HTH "Mitch" wrote: I want to search a range of cells, say C:C for a value, if that value is there i want to multiply the corresponding B cell and D cell together then sum up all of the true values. If anyone can help me please let me know. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need a productif style function
I entered your fuctions just as you wrote but it still doesn't work, I just
get a #VALUE! error. Also I'm not sure what the -- are for. Thanks for your help so far. "Toppers" wrote: Try something like: =SUMPRODUCT(--(C1:C10="A"),--(B1:B10),--(D1:D10)) Sum the products of B*D when C="A" HTH "Mitch" wrote: I want to search a range of cells, say C:C for a value, if that value is there i want to multiply the corresponding B cell and D cell together then sum up all of the true values. If anyone can help me please let me know. Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need a productif style function
This is the function I ended up using
=IF(SUMIF(C2:C41,"Winter 2006",E2:E41)0,(SUMPRODUCT(--(C1:C41="Winter 2006"),(B1:B41),(E1:E41))/SUMIF(C1:C41,"Winter 2006",B1:B41)),"") It works perfectly, thanks for your help. "Toppers" wrote: Try something like: =SUMPRODUCT(--(C1:C10="A"),--(B1:B10),--(D1:D10)) Sum the products of B*D when C="A" HTH "Mitch" wrote: I want to search a range of cells, say C:C for a value, if that value is there i want to multiply the corresponding B cell and D cell together then sum up all of the true values. If anyone can help me please let me know. Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need a productif style function
No problem .. thanks for the feedback.
"Mitch" wrote: This is the function I ended up using =IF(SUMIF(C2:C41,"Winter 2006",E2:E41)0,(SUMPRODUCT(--(C1:C41="Winter 2006"),(B1:B41),(E1:E41))/SUMIF(C1:C41,"Winter 2006",B1:B41)),"") It works perfectly, thanks for your help. "Toppers" wrote: Try something like: =SUMPRODUCT(--(C1:C10="A"),--(B1:B10),--(D1:D10)) Sum the products of B*D when C="A" HTH "Mitch" wrote: I want to search a range of cells, say C:C for a value, if that value is there i want to multiply the corresponding B cell and D cell together then sum up all of the true values. If anyone can help me please let me know. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| VBA | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| clock | Excel Worksheet Functions | |||
| Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Linear Mode
