subract from sum?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I sum a column but excluded certain figures based on another cell
 
Hi
=SUM(B1:B100)-SUMIF(A1:A100,"X",B1:B100)

or
=SUMIF(A1:A100,"<>X",B1:B100)

--
Regards
Frank Kabel
Frankfurt, Germany

starrpro said:
How can I sum a column but excluded certain figures based on another
Click to expand...
cell
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtract then Add Results 5
Subtracting Dates to get total time work time excluding weekends 2
Is there a way to subtract a column of numbers? 1
Making a cell show blank until data is entered 2
Numbers showing Up Centered in Cell ? 1
Excel text formula 2
Subtracting based on 2 conditions 3
subtract column E to column D in every row 5

Back
Top