Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SumProduct Assistance Please
I am trying to sum 2 columns together and multiple it by another cell if one
criteria is met. The formula I am using is not working and displays #value. It is =SUMPRODUCT(--(A12:A149=A4),C12:C149+H12:H149)*D2 Data looks like this A1=Blue D2=4.5% Column C and H contain sales dollars So if A12:A149 = Blue Then sum the Columns C12:C149 and H12:149 and multiply the Total of Columns C & H by the 4.5 % in cell D2 TIA for your assistance. This forums has assisted me with many formulas to date, but can't seem to find one that helps with this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT assistance | Excel Worksheet Functions | |||
Sumproduct assistance - need multiple ANDs and ORs | Excel Worksheet Functions | |||
Sumproduct assistance | Excel Worksheet Functions | |||
SUMPRODUCT Assistance | Excel Worksheet Functions | |||
I Need VBA Assistance for EOF | Excel Discussion (Misc queries) |