Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Do I need SUMPRODUCT?
The following is a formula I am using that totals a range meeting a
single criteria. =SUMIF(D2:D254,D507,E2:E254) However, I now want to give an additional condition; that is (F2:F254) = "" I think I want SUMPRODUCT but I am not sure how to use it? Can anyone help? My thanks to those who can. Dave Moore |
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 |