SUMPRODUCT *doesn't* work with entire column references:
A:A, B:B, C:C
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Duke Carey" wrote in message
...
=sumproduct(--(A:A="Tony"),--(B:B="Phil"),C:C)
will return a zero value if Tony & Phil aren't side by side in columns A &
B, but if they are side by side, will return the value in column C
"Phil" wrote:
Hi,
I am trying to find a formula that will look up a text value in Column A
then compare it to the corresponding cell in columnB and copy the
numbers in
column c.
For instance...
Look down Column A for "Tony". If Tony is in ,say, A5 then look at B5
for
"Phil" and if B5 = Phil then copy number in C5. If B5 not equal to Phil
then
do nothing.
Hope i explained it ok.
Thanks.
|