problem

Copper Contributor

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.

6 Replies

@Recepcja 

I assume that you want to count "uw"s.

Let's say you want to look at B2:Z2.

 

=8*COUNTIF(B2:Z2,"uw")

 

This can be filled down if required.

It's not working, shows up as a mistake

@Recepcja 

Sorry, my reply contained a typo. I have corrected it:

 

=8*COUNTIF(B2:Z2,"uw")

It is the same as it was before and still not working

@Recepcja 

Do you use comma as decimal separator? If so, the formula should use a semicolon ; instead of a comma:

 

=COUNTIF(B2:Z2,"uw")

 

If that does not work either, please explain in detail what you want to do, and preferably attach a small sample workbook.

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)