Yet more Excel - exclude certain cells in a sum

Bleek · 21 Jan 2011 at 13:24

I literally have two columns, Column A has a drop-down box with 'ok' or 'ignore'.

The column to the right column B, simply has a number.

I want to be able to add all these numbers in column B ONLY if column A says 'ok'.

I tried googling it but trying to word it right seem a chore, didn't find much to help me?

Bleek · 21 Jan 2011 at 14:28

Thank you!

Bleek · 21 Jan 2011 at 15:02

Can you use the SUMIF with a COUNTIF?

For example I have this formula that counts only 'W'

=COUNTIF($R$5:R44,"W")

So could you combine that with =SUMIF(A1:A10, "ok", B1:B10)

i.e. only count the 'W' and do the sum if you have an 'ok' too?

Bleek · 21 Jan 2011 at 17:36

I don't need the B1 aspect, just the check for 'ok' and 'w'.

I need to count how many times an ok and w fall in the same row, if that makes sense?

And thank you for your excellent reply and in taking the time to help - much appreciated!

Bleek · 26 Jan 2011 at 12:17

Bleek said:
I don't need the B1 aspect, just the check for 'ok' and 'w'.

I need to count how many times an ok and w fall in the same row, if that makes sense?

And thank you for your excellent reply and in taking the time to help - much appreciated!

Anyone, I still can't work it out from the above example and the 2002 help file is a bit limited.

Perhaps it's time for an upgrade!