excel countif function

[FunkyGibbon]

Anyone know if you can use the countif function in the following manner - as I can seem to work it out?

count the number of items in column F only if the corresponding cell column B = 1

TIA

[boiler]

As you are counting the number 1, you could multiply the countif function by the value in column F. Something like this...

=F1*COUNTIF(B1,1)

[thegreenhell]

COUNTIF will only tell you the number of instances of the value "1" in column B.
If you want to use this value as a trigger to add up the values in column F (which is what I think you are asking) then use the SUMIF function.

eg. =SUMIF(B1:B12,1,F1:F12) will add up the numerical values contained in the cells in column F only if the corresponding cell in column B is equal to 1.

Hope that helps.

[FunkyGibbon]

thegreenhell said:

COUNTIF will only tell you the number of instances of the value "1" in column B. If you want to use this value as a trigger to add up the values in column F (which is what I think you are asking) then use the SUMIF function. eg. =SUMIF(B1:B12,1,F1:F12) will add up the numerical values contained in the cells in column F only if the corresponding cell in column B is equal to 1. Hope that helps.

that should do it.

thanks.