Forum Discussion
problem
I need a formula that will sum every "uw" from line and then multiply it by 8. It sounds simple but I have no idea how to do it.
Not sure if this is what you are traying to do.
Example
H I
UW 100
UW 200
UW 100
UW 80
Ub 5060
Ub 40
Ub 5080
Ub 100
Ub 340
480. formula: SUMIF(H196:H204,"uw",I196:I204)
Example
H I
UW 100
UW 200
UW 100
UW 80
Ub 5060
Ub 40
Ub 5080
Ub 100
Ub 340
480. formula: SUMIF(H196:H204,"uw",I196:I204)