Hi All.
I must really be thick this am. I have the COUNTA and the COUNTIF thing figured ...but...I cannot seem to get this straight:
Column A - always contains a "1" if there is any entry in that Column.
Column B - always contains a "2" if there is any entry in that Column.
I need to have the number of "1"s added up in Cell C1 only if there is also a "2" in Column B as well. If there is an erroneous value in A:A - maybe a 3 or something gets in there by mistake - I do not want it counted (as this may occur) so I only want to count the "1"s and not add them.
I thought - at first - to make this an array...but then I couldn't figure why my numbers in C1 were so whacky...I was getting 9...I was using sum. "D'oh!"
I tried to use the COUNTIF, but never figured out a way to set a second criteria...and I want to do this without using Conditional Formatting.
Can I do this? I tried a few examples of things that I found in search but, they were only close and not quite what I was looking for.
Thanks for taking a look!!
Regards,
ViperGTS
This message was edited by ViperGTS on 2002-11-06 09:53
This message was edited by ViperGTS on 2002-11-06 10:50
I must really be thick this am. I have the COUNTA and the COUNTIF thing figured ...but...I cannot seem to get this straight:
Column A - always contains a "1" if there is any entry in that Column.
Column B - always contains a "2" if there is any entry in that Column.
I need to have the number of "1"s added up in Cell C1 only if there is also a "2" in Column B as well. If there is an erroneous value in A:A - maybe a 3 or something gets in there by mistake - I do not want it counted (as this may occur) so I only want to count the "1"s and not add them.
I thought - at first - to make this an array...but then I couldn't figure why my numbers in C1 were so whacky...I was getting 9...I was using sum. "D'oh!"
I tried to use the COUNTIF, but never figured out a way to set a second criteria...and I want to do this without using Conditional Formatting.
Can I do this? I tried a few examples of things that I found in search but, they were only close and not quite what I was looking for.
Thanks for taking a look!!
Regards,
ViperGTS
This message was edited by ViperGTS on 2002-11-06 09:53
This message was edited by ViperGTS on 2002-11-06 10:50