Smarter Idea
Look in HELP for the SUMIF() function
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Lp12" wrote in message ...
| Hi All,
| I have to check if there is data in B1:B3 (for example the entry '12') if
| so, I need to add/sum the number that is written in the parallel cell in
| A1:A3.
| For example if in B1 = o,B2=12,B3=12 and in A1=1,A2=2,A3=3. then the total
| (represent in cell C1) will be 5. I accomplished that by using IF sentence
| for each entry. Is there a more smart way to do this?
| Thanks a lot in advance
|
|