Floyd

iTrader: (9)

It's probably very simple but I can't work it out, IT support can't help and niether can a group of Excel trainers!

The problem is that I need a calculation to count the number of zero's in column b but only if the zero's coincide with a letter in column a.

Pleeease help!!!!
You will be a true excel Guru if you can.

F

Floyd

iTrader: (9)

top

ChrisB

First Question - what version of Excel.

Second Question - Why can't you just count the letters in the first column?

Does it look anything like this?



Appologies if I've got the wrong end of the stick.

Chris.



[This message has been edited by ChrisB (edited 16 March 2001).]

Puff The Magic Wagon!

iTrader: (2)

Glad its a problem with Microsoft Excel rather than my company, Excel Couriers

robski

add this in a new column

where column a is the letter column
b is the number column

=IF(A1="a",IF(B1=0,1,0),0)

then add the total of the new column
(it will put a 1 where both are met, otherwise a zero)

very inelligant formula I know, but aint got time to do anything better

robski

robski

oops just realised, I thought you meant an a in the first column

=IF(ISTEXT(A1)=TRUE,IF(B1=0,1,0),0)

this should work!

robski

robski

Floyd,

you sorted now?

robski

Floyd

iTrader: (9)

Thanks guys, I'll try it out now and let you know.

F

Floyd

iTrader: (9)

Robski

You are indeed a true guru! I bow down to you of mighty one!

Thanks
F