CODEWITHSUNDEEP
excel
Megan
Megan

Reputation: 31

Adding multiple if statements together

I'm making a spreadsheet with different books people have to read and when the person gets finished reading the books they will mark and x and the box. So I have a formula for the following book columns E3,G3,I3and K3 which is COUNTIF(B3:L3,"X")*20. Can I add this formual to another so that N3 and O3 are worth 2.5?

Upvotes: 1

Views: 5451

Answers (3)

kennytm
kennytm

Reputation: 523184

Use SUMIF.


(source: xanga.com)

(result should be 76%)

Use COUNTIF if the value is fixed.


(source: xanga.com)

Upvotes: 1

xtofl
xtofl

Reputation: 41509

You can work with a nested IF, but this may soon become complicated.

In this case, I usually work with a hidden column containing the 'weight' of the column to be marked: say that column A contains the marker for volume A, then column B would contain 20%, and C would contain =IF( A <> "", B, 0 );

Then the sum column would contain =SUM(C,F,I);.

(example: some google doc I made)

Upvotes: 2

Peter Lang
Peter Lang

Reputation: 55524

You can cascade them:

=IF( A1="x", 10, IF( A2="X", 20, 0 )

Have a look at COUNTIF though, if every X adds the same value:

=COUNTIF( A1:A20, "X" )

Upvotes: 1

Related Questions