Get the SUM based on multiple IF Statements-CodePudding

Home > front end > Get the SUM based on multiple IF Statements

Get the SUM based on multiple IF Statements

Time：05-05

The need is to get the SUM for all cells D2:K2. The cells values are encoded, want to replace 11 by 1, 10 or 1 by 0.5 finally 0 by 0 while performing the sum operation.

Below the tried formula but not working:

=SUM(IF(D2:K2=11,1,IF(D2:K2=10,0.5,IF(D2:K2=1,0.5,0))))

Need help please!

CodePudding user response：

A sum of regular COUNTIF() functions ?

=COUNTIF(D2:K2,11)*1 COUNTIF(D2:K2,10)*0.5 COUNTIF(D2:K2,1)*0.5

Page link：https//www.codepudding.com/frontend/396474.html

Prev:vba: skip a yes/no action within a loop in sending outlook email thru excel

Next:Check multiple rows for a unique combination across a whole table

Tags：

excel

excel-formula

Links：
CodePudding