Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct
I am trying to sum with 3 criteria but not as complicated as in different
row. I tried this formula but it doesn't seem to work. I want to sum if the column equals, f,eb, fb.l The would be or so I asking sum all cells that have an f+eb+fb. =SUMPRODUCTR((L7:L2589=f)*(L7:L2589=FB)*(L7:L2589= EB)) Please help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct
try using quotes for text and NOT for numbers.
=SUMPRODUCT((L7:L2589="f")*(L7:L2589="FB")*(L7:L25 89="EB")) -- Don Guillett SalesAid Software "Rob" wrote in message ... I am trying to sum with 3 criteria but not as complicated as in different row. I tried this formula but it doesn't seem to work. I want to sum if the column equals, f,eb, fb.l The would be or so I asking sum all cells that have an f+eb+fb. =SUMPRODUCTR((L7:L2589=f)*(L7:L2589=FB)*(L7:L2589= EB)) Please help |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct
It doesn't look like you're summing anything. Are you just trying to count cells in your range equal To "F", "EB" or "FB"? If so =SUM(COUNTIF(L7:L2589,{"F","FB","EB"})) ...or =SUMPRODUCT(--(L7:L2589={"F","FB","EB"})) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=508771 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct causing memory errors? | Excel Worksheet Functions | |||
Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |