help with formula please

[Richard]

Can anyone please help with this formula. If Sheet1 Column
A = nothing(blank) And Column B = \\\\\\CC\\\\\\ Then
Sheet 2 B7 = SumTotal. As a regular formula would be nice
or VB code

 

[JulieD]

Hi Richard

you want nothing at all in the whole of column A in sheet 1?
do you want every cell in column B of sheet 1 to have \\\\\\CC\\\\\\ or
should this (can this) only appear in one cell?
and what range are you summing on sheet 2 in cell B7?

Cheers
JulieD

 

[Guest]

There is sometimes something in Column A and sometimes
not, therefore I want to sum everything in Column A And
Column B that meet both requirements. Such as: If A1 has
something in it , then don't sum it, if A2 has nothing in
it and B2 does not have \\\\\\CC\\\\\\, then don't sum it,
but if for example A2 has nothing and B2 has
\\\\\\CC\\\\\\ then sum it. Make since, kind of confusing
to put in words. But thanks for your help.

 

[Frank Kabel]

Hi
see your other post

 

[JulieD]

Hi Richard

(can't find your other post that Frank mentioned so i'll reply here just in
case ...)

still confused as to what you're summing ... you want nothing in A and a
non-numeric in B which AFAIK you can't add
however the IF part of the question is along the lines of
=IF(OR(A1<>"",B1<>"\\\\\\CC\\\\\\"),"don't sum","sum")

replace "don't sum" and "sum" with what ever you want to happen (if numeric
remove the ")

Cheers
JuileD