Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum if
Hi,
in b2, am trying to put a formula that should :if(sum(B2:B5),=A1 otherwsie Give me error A1 is a link from other sheet i've put the following formula but its not working: =IF(SUM(B3:B5)=A1,"Error") A B 1 81 2 Position title 5 3 Position title 4 4 Position title 3 5 Position title 6 Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum if
Sounds like you want
=IF(SUM(B2:B5)=A1,"OK","Error") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Batshon" wrote in message ... Hi, in b2, am trying to put a formula that should :if(sum(B2:B5),=A1 otherwsie Give me error A1 is a link from other sheet i've put the following formula but its not working: =IF(SUM(B3:B5)=A1,"Error") A B 1 81 2 Position title 5 3 Position title 4 4 Position title 3 5 Position title 6 Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|