Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() What's Wrong With This Formula? =SUMPRODUCT((C11:$C$65536="I*")*(F11:$F$65536=F10) *(E11:$E$65536)) - I'm using Excel 2000 - Column C contains text values - Column F contains text values - Column E contains numeric values - My formula is in cell E10 - I want to sum cells in column E below the row containing this formula using the following criteria... - This formula is returning 0 Criteria: 1) cells in column C whose text values start with "I" 2) cells in column F whose text values equals the text value in cell F10 Note: - The purpose of the mixed references (i.e. relative/absolute) is because I need to copy this formula down but it should just evaluate cells below the row containing the formula. - I've tried using F11 instead of F10 but I'm still returning 0 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
What is wrong with this formula? | Excel Worksheet Functions | |||
What is wrong with formula? | Excel Worksheet Functions | |||
What's wrong with this formula? | Excel Discussion (Misc queries) | |||
Help please,what is wrong with this formula? | New Users to Excel |