Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
I'm working in a worksheet that has: A B C D H 1 8 5 7 6 2 EXX GAL SHE EXX ... EXX 3 25 30 20 15 290 4 21 45 30 12 240 5 45 36 21 36 576 I need to put in the H column: (25*8)+(15*6)= 290 with the criteria EXX (21*8)+(12*6)= 240 " I think that I should use a SUMPRODUCT or a SUMIF but I don't know how Can you help with this?? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sumif vs sumproduct | Excel Worksheet Functions | |||
Sumif or Sumproduct | Excel Worksheet Functions | |||
Sumif or Sumproduct 2 criterias not working | Excel Discussion (Misc queries) | |||
Sumif not Sumproduct | Excel Worksheet Functions | |||
SUMIF or SUMPRODUCT or something else? | Excel Worksheet Functions |