problem

%3CLINGO-SUB%20id%3D%22lingo-sub-2864398%22%20slang%3D%22en-US%22%3Eproblem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2864398%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20a%20formula%20that%20will%20sum%20every%20%22uw%22%20from%20line%20and%20then%20multiply%20it%20by%208.%20It%20sounds%20simple%20but%20I%20have%20no%20idea%20how%20to%20do%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2864398%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2864665%22%20slang%3D%22en-US%22%3ERe%3A%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2864665%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1190653%22%20target%3D%22_blank%22%3E%40Recepcja%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20assume%20that%20you%20want%20to%20%3CEM%3Ecount%3C%2FEM%3E%20%22uw%22s.%3C%2FP%3E%0A%3CP%3ELet's%20say%20you%20want%20to%20look%20at%20B2%3AZ2.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3D8*COUNTIF(B2%3BZ2%2C%22uw%22)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20can%20be%20filled%20down%20if%20required.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2864818%22%20slang%3D%22en-US%22%3ERe%3A%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2864818%22%20slang%3D%22en-US%22%3EIt's%20not%20working%2C%20shows%20up%20as%20a%20mistake%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2864949%22%20slang%3D%22en-US%22%3ERe%3A%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2864949%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1190653%22%20target%3D%22_blank%22%3E%40Recepcja%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESorry%2C%20my%20reply%20contained%20a%20typo.%20I%20have%20corrected%20it%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3D8*COUNTIF(B2%3AZ2%2C%22uw%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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)