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 Can you help with this?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMPRODUCT or SUMIF or ... | Excel Worksheet Functions | |||
SumIf or SumProduct or If statements | Excel Worksheet Functions | |||
Sumif or Sumproduct | Excel Worksheet Functions | |||
Sumif not Sumproduct | Excel Worksheet Functions | |||
SUMIF or SUMPRODUCT or something else? | Excel Worksheet Functions |