Oct 20 2021 02:15 AM
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.
Oct 20 2021 03:28 AM - edited Oct 20 2021 04:57 AM
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.
Oct 20 2021 04:57 AM
Oct 20 2021 08:00 AM
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.
Oct 20 2021 08:13 AM